TOP 1 WITH TIES

Where How Many Times you want To GO Today !

This is about a really INTERESTING SQL server 2005 feature.

You can execute a transact sql batch any number of times just by Giving the number with GO.

See Go in action here

PRINT 'Hai.. How many times you expect to see this message..?'
GO 10

And here is the output.

Beginning execution loop
Hai.. How many times you expect to see this message..?
Hai.. How many times you expect to see this message..?
Hai.. How many times you expect to see this message..?
Hai.. How many times you expect to see this message..?
Hai.. How many times you expect to see this message..?
Hai.. How many times you expect to see this message..?
Hai.. How many times you expect to see this message..?
Hai.. How many times you expect to see this message..?
Hai.. How many times you expect to see this message..?
Hai.. How many times you expect to see this message..?
Batch execution completed 10 times.


Thats COOL right?