StumbleUpon
Share on Facebook

Thursday, December 16, 2010

How to Specify Foriegn Key Relationships in SQL Server 2008

Foriegn Key in SQL Server 2008 - Use the Relationships option


Specify the relationship between the columns


StumbleUpon
Share on Facebook

Unable to change Identity Specification in SQL Server 2008

Unable to change Identity Specification in SQL Server 2008

StumbleUpon
Share on Facebook

How to make Server Explorer visible in Visual Studio

Server Explorer not visible in Visual Studio

StumbleUpon
Share on Facebook

Your pending changes require the following tables to be dropped and re-created


Remove the checkbox 'Prevent saving changes'
StumbleUpon
Share on Facebook

How to create auto-increment column in SQL Server

How to Set Increment value in SQL Server

Set Column properties - goto Identity Specification, set (Is Identity) to True (Yes)


SQL Server Identity Specification

StumbleUpon
Share on Facebook

How to specify Default value for a column in SQL Server

SQL Server Default Column Values

Here is a way to specify default values in Sql Server Management Studio for a column

Related Posts Plugin for WordPress, Blogger...