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


能否在 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才会显示红色。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值