--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
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