Stairway to T-SQL: Beyond The Basics Level 7: Controlling the Flow of Your T-SQL

http://ift.tt/1loAO22

When you are writing TSQL code there are times when you want to perform the same logic over and over again. To accomplish this you can used the WHILE keyword. There are other times when you want to perform a conditional test and depending on the results of the test you execute one code block for the TRUE condition and possibly a different code block when the condition is FALSE. When you need to conditionally execute code based on the outcome of a condition you can used the IF keyword. In this Stairway level I will be discussing how to use the WHILE and IF constructs to control the flow of your TSQL code.

from SQLServerCentral.com Articles http://ift.tt/Y4GoHZ