Print Result Set Sql Server. Query of SQL Server. We use the SQL Server PRINT statement to return messages to the client.
We use the SQL Server PRINT statement to return messages to the client. Sql server 2012 display result set of database. When executing the query below if I use PRINT it prints correctly.
When executing the query below if I use PRINT it prints correctly.
Usually we use the SQL PRINT statement to print corresponding messages or track the variable values while query progress. Query of SQL Server. This feature allows us to modify the column names and column data types of the result sets returned by a stored procedure without actually modifying the stored procedure code. It is not uncommon to have stored procedures returning result sets and although it sounds like a good idea it becomes a problem when you want to have control of the name of the columns and data type of the columns being returned as part of the result set.