I have used Visual Basic. Aren't there more program flow statements that I could use, such as CASE and FOR-NEXT?
A2:
No. The IF and WHILE statements will provide you with as much control as you would need. The CASE statement is not used for controlling the flow of execution in T-SQL. It is most often used for conditional execution inside a SELECT or UPDATE statement.