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) );
creating an Identity column
Tuesday, 1 March 2011
Subscribe to:
Post Comments (Atom)
1 comments:
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
Post a Comment