Thursday, July 28, 2005

 

How Many Times you want To GO Today

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?

Comments:
free themeforest templates from Template Plaza. If you need it, just cheek link and I'll pm you direct download link.
www.templatedesk.com
 
Post a Comment

<< Home

This page is powered by Blogger. Isn't yours?