Tuesday, June 28, 2011

Identity Column in SQL

Use following to make an identity column in a table of SQL database.

CREATE TABLE dbo.TableName(
ID INT IDENTITY(1,1) ,
LittleDescription varchar(50) ,
DetailedDescription varchar(1000)
);

No comments:

Post a Comment