Appendix D: Advanced SQL Query Techniques

In This Appendix

This appendix will show you various tricks and techniques that you can use with SQL queries.

These include:

• Advanced insertion and deletion

• Recursive stored procedures

• Dynamic queries

• Stored procedure generator

• GROUP BY with CUBE and ROLLUP

• Server cross tabulations with SQL

  Note 

  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.