在SQL Server Management Studio (SSMS)中使用字体颜色

最新推荐文章于 2025-02-28 12:23:34 发布

翻译最新推荐文章于 2025-02-28 12:23:34 发布 · 4.5k 阅读

文章标签：

#sql server #ssms #object #database #output #table

ssms 专栏收录该内容

1 篇文章

订阅专栏

探讨了在SQL Server Management Studio (SSMS)中是否能够通过SQL命令改变消息面板输出的字体颜色。文章指出直接通过SQL命令改变颜色不可行，并提供了一种使用RAISERROR来标记错误的方法。

能否在 SQL Server Management Studio (SSMS) 的消息面板输出中，通过 SQL print 命令改变默认字体颜色？

IF @@TRANCOUNT>0 BEGIN
PRINT 'The database update succeeded'
COMMIT TRANSACTION
END
ELSE PRINT 'The database update failed'
GO

I.e

Not as far as I know, you would have to change the color of all text in the editor, I'm pretty sure that's not what you want.

You have to realize for the Management Studio, everything you output is just text, how is it supposed to know that it's representing an error?

PRINT '--################### ERROR BEGINS ##################' PRINT 'The database update failed' PRINT '--################### ERROR ENDS ####################' I will wrap it in thins as this is my only other option. – icecurtain Mar 2 at 10:20
does that actually color the message red? – ntziolis Mar 2 at 10:21
No as you mention it is not exposed.So I will have to highlight the error using thins, I could change the font but that will effect all of the message. May be there is a T-SQL statement to force a error with a text output? –


declare @object_name varchar(20)='test_table1',@message varchar(50)
if object_id(@object_name) is not null
begin
select * from PUB_INDIV_CSRC_SESS
end
else
set @message=@object_name+' 不存在!'
RAISERROR (N'''%s'' 不存在，错误号 %d', -- Message text.
               16, -- Severity.
               1, -- State.
               @object_name, -- First argument.
               1 -- Second argument.
               ) WITH NOWAIT;
go

参考：http://technet.microsoft.com/zh-cn/library/ms178592(v=sql.90).aspx

错误级别大于10才会显示红色。