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