creating an Identity column

Tuesday, 1 March 2011

This will create an identity column in the following table.
CREATE TABLE dbo.MyTable (    ID INT IDENTITY(1,1)    ,MyShortDesc varchar(20)     ,MyLongDesc varchar(500)    );

1 comments:

Anonymous said...

sql errors often cause problems for us and most of the time the abend search tools are not helpful in getting to the root cause, one such code is -904