数据库同步之后,数据库标识列从1开始计数,使用以下语句重置所有数据表的标识列。
declare c_a cursor for SELECT name FROM sys.sysobjects WHERE type='U';
declare @id nvarchar(100);declare @sql nvarchar(1000);
open c_a;
fetch next from c_a into @id;
while @@fetch_status=0
begin
set @sql='DBCC CHECKIDENT ("'+@id+'", RESEED)';
exec sp_executesql @sql
fetch next from c_a into @id;
end;
close c_a;
deallocate c_a;