开发者

How do I clear the result message data from a SQL query while in the middle of the query?

开发者 https://www.devze.com 2023-02-27 01:25 出处:网络
I am currently using MS SQL Server 2008. I have a stored procedure that sends an email using sp_send_dbmail. sp_send_dbmail prints \"Mail Queu开发者_StackOverflow中文版ed\" to the result message. I n

I am currently using MS SQL Server 2008.

I have a stored procedure that sends an email using sp_send_dbmail. sp_send_dbmail prints "Mail Queu开发者_StackOverflow中文版ed" to the result message. I need to erase this from the result message. Is there a way to fully clear what has been printed to the result message or to mute "print" commands like this from populating at all?


The @exclude_query_output argument suppresses it. By default is set to 0 so you just set it to 1.

More information at documentation: sp_send_dbmail

0

精彩评论

暂无评论...
验证码 换一张
取 消