SQL Server Management Studio (SSMS) is pretty good for developing and checking tabular data; but trying to use the results table to check formatting of text (varchar) output can be challenging. Luckily the T-SQL
PRINT statement can help. The
PRINT statement sends the formatted output to the
Messages tab in SSMS.
See my example below.
Output in the Results Tab table
Output in the Messages Tab
More information on the PRINT Statement can be found below:
Let me know in the comments if you found this helpful (or not).
No comments:
Post a Comment