How To Print Result Set Sql. ResultSetMetaData rsmd rsgetMetaData. If the query returns zero rows then the variable is set to EMPTY ie NULL.
ALSO READ PRINTSELECT Statement messages within WHILE LOOP or BATCH of statement is not displayed immediately after its execution- Sql Server. Here is another SO question and answer that shows an example very similar to this one with reference to the PRINT documentation. ResultSetMetaData rsmd rsgetMetaData.
Starting with SQL Server 2017 you can now make your query results appear as a list.
While rsnext for int i 1. In either case the language does not allow a sub query as an argument to the PRINT command. Unlike SET if the query results in multiple rows then the variable value is set to the value of the last row. Say if your.