Monday, July 9, 2012

While Loop...SQL

SQL allows to write 'while' loop as like normal program languages. But we should take care of begin and end blocks. All the statements should lie in between BEGIN and END blocks only.

Following are the sample While Loop Examples:

Eg1: Print the numbers upto 100
Example 2



Example 2

































No comments:

Post a Comment