如何暂时抑制 SSMS 中的错误消息？

发布于 2024-11-16 01:12:15 字数 322 浏览 3 评论 0原文

以下命令尝试为当前数据库中的所有表重新设定标识值。

exec sp_MSforeachtable @command1 = 'DBCC CHECKIDENT(''?'', RESEED, 1)'

对于每个没有标识列的表都会生成一条错误消息。

消息 7997，级别 16，状态 1，第 1 行“MyTable”不包含标识列。

我想抑制上面这一行代码的所有错误消息，但不抑制 SQL 文件中其余代码的错误消息。

有什么想法吗？

原文

The following command attempts to reseed the identity value for all tables in the current database.

exec sp_MSforeachtable @command1 = 'DBCC CHECKIDENT(''?'', RESEED, 1)'

An error message is generated for each table that does not have an identity column.

Msg 7997, Level 16, State 1, Line 1 'MyTable' does not contain an identity column.

I would like to suppress all error messages for this single line of code above, but not suppress them for the rest of the code in the SQL file.

Any ideas?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

上课铃就是安魂曲 2024-11-23 01:12:15

你可以做这样的事情（未经测试，但我想你会明白要点）：

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

You can do something like this (untested, but I think you'll get the gist):

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

回复收藏 0 原文

~没有更多了~