|
|
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. |
|
|