请高手指教:如何去掉这些提示?
格兰特杨 2002-09-13 05:29:46 在SQL Server中撰写存储过程,
可以在开头使用SET NOCOUNT ON来实现不显示更新了多少行。
是否有类似的开关语句,来实现不显示在重新生成索引命令
DBCC DBReindex
时的
Index (ID = 2) is being rebuilt.
Index (ID = 3) is being rebuilt.
Index (ID = 4) is being rebuilt.
Index (ID = 5) is being rebuilt.
Index (ID = 6) is being rebuilt.
Index (ID = 7) is being rebuilt.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
和在一些GroupBy语句中的
Warning: Null value eliminated from aggregate.
这样的话?否则,商业的存储过程总是显得不那么干净。
先谢过了!