我来回答
set identity_insert table_name on
set identity_insert yourtable on
insert yourtable (no,...) values(3,...)
set identity_insert yourtable off
go
set identity_insert table_name on
set identity_insert yourtable on
insert yourtable (no,...) values(3,...)
set identity_insert yourtable off
go
没办法的,IDENTITY ( data_type [ , seed , increment ] ) 函数需要用在有into的语句中。Example :select IDENTITY(int,1,1) as FIndex,.... Into #t_Queery From TableName Where ...select * from #t_Querrydrop table #t_Querry