identity 풀고 싶을때

http://blog.mesmerist.net/8

set identity_insert dbo.event on

반듯이 아래와 같이 컬럼을 넣어줘야함

Insert A(컬럼명..)

Select * from B

set identity_insert dbo.event off

 

관련 생성 쿼리

select 'set identity_insert dbo.' + b.name +' on '
, 'insert into ' + b.name + ' ( '+
 STUFF((SELECT ',' + name 
    
       FROM sys.columns B
       WHERE B.object_id = A.object_id
       FOR XML PATH('')
      ),1,1,'')
       + ' ) select * from [mesj].mes_sep.dbo.' +b.name + ' '
, 'set identity_insert dbo.' + b.name +' off '
 from sys.identity_columns a
inner join sys.tables b
on a.object_id = b.object_id