Monday 24 October 2011

Insert Data in Auto Incremented column Table

--Stop Identity of table and then insert data whichever we need and again start identitiy....
SET IDENTITY_INSERT tablename ON

insert into tablename(id,name,descr)
select id,name,descr
from tablename

SET IDENTITY_INSERT tablename OFF

No comments:

Post a Comment