Advanced insertion and deletion
Recursive stored procedures
Stored procedure generator
GROUP BY with CUBE and ROLLUP
Server cross tabulations with SQL
In this appendix, all examples will use the Northwind database, as is the case throughout the book. Some of the examples in this appendix will cause deletion of data. It is, therefore, recommended that you back up the Northwind database so that you can restore it after you are done with this appendix.