Print a text N number of times in SQL Management Studio

When working with SQL Management studio , you might need to display a string N number of times , in this case , simply use the GO command and specify the number of times you want the batch to be repeated.

How to print a text ‘N’ number of times in SQL Management Studio ?

For example , you want to display a string ‘This is’ 10 times. Here’s how you will do it.

PRINT 'This is'
GO 10


If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


Interesting BlogPosts to read

How to print title on every page in Microsoft Excel?
Most of the time we might end up having a long workbook with huge amount of data and they have lot o...
How to quickly remove multiple line breaks in Excel using VBA code?
There are times when you might copy few data from different source and you would end up getting unne...
How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...