Serveroutput from a Tsql Procedure

I want to write a message on the console in the SQL Server Management Studio with a TSQL procedure. Basically the same thing as

set serveroutput on
dbms_output.put_line ('hello');

does in Oracle. Hows can I do this?

1 Answer

Use Print..

Print 'Hello world'

For variabless..

print @a
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Sophia Al-Mansoor

Sophia Al-Mansoor

Global Business & E-Commerce Reporter

Sophia analyzes international trade, startup ecosystems, retail transformation, and supply chain logistics for modern digital publications.

Share this article
Twitter Facebook Pinterest