429
Chapter 16: Programming with T-SQL
16
■ (^) IF controls only execution of the next line, unless it is followed by a BEGIN...END
block.
■ (^) Variables can be incremented with +=.
■ If the temporary space needs to hold more than 250 rows, then use a temp table;
otherwise, use a table variable.
Chapter 17 moves into the next important step in T-SQL programming, stored procedures.
This is where you take advantage of your knowledge of fl ow-control and make your proce-
dures fl exible and powerful.
c16.indd 429c16.indd 429 7/30/2012 5:38:13 PM7/30/2012 5:38:13 PM
http://www.it-ebooks.info