Like this:

I thought I would pass along something I learned this week about batches in TSQL. I always knew about the GO statement terminator, but I didn’t know you could takc on a number to it and get it to repeat itself.

 

For Example:

Select top 5 * From FactOnlineSales
GO 100

I guess we learn something new every day! Keep posting your comments and feedback. I love it!

Advertisement