Let SQL Server 2008 R2 output information at query time

Environment: SQL Server 2008 R2

Problem: Output information at query time

Solve:

One: Use the print function.

Such as:

print ' HelloWorld ';

Of course, the print function will not only be able to print strings, but also print integer data or floating-point data.

Such as:

print;  
Print 39.27;  
Print 0.11111111111111111111;

Two: The workaround method, obtains the output information through the system table query.

select * from sysobjects;  
      
Select ' HelloWorld ' from sysobjects where id = 3;