SQL is not a procedural language and thus contains no control-of-flow constructs.

Transact-SQL is a SQL Server specific extension of SQL. It does contain some control-of-flow language bits and pieces. You can read about that in Books Online by searching on "control-of-flow language".