Monday, March 27, 2006

Adding identity with seed and increment in SQL Server 2005

Here are the commands to be followed

create table test ( num int, num1 int);
insert into test values( 8,9)
alter table test add numX int IDENTITY (1, 1)

-kalyan

No comments: