如何暂时抑制SSMS中的错误消息？
|
以下命令尝试重新设置当前数据库中所有表的标识值。
exec sp_MSforeachtable @command1 = \'DBCC CHECKIDENT(\'\'?\'\', RESEED, 1)\'
没有找到相关结果
已邀请:
1 个回复
良阑纠苫
declare tbls cursor for select object_name([object_id]) from sys.identity_columns where objectproperty([object_id], \'IsMSShipped\') = 0 declare @tbl_name sysname, @cmd nvarchar(max) open tbls while(1=1) begin fetch next from tbls into @tbl_name if(@@fetch_status <> 0) break set @cmd = \'DBCC CHECKIDENT(\'\'\' + @tbl_name + \'\'\', RESEED, 1)\' exec(@cmd) end close tbls deallocate tbls