Two Handy Techniques for Creating Dynamic SQL in Stored Procedures

Describes two techniques to use when generating dynamic SQL in stored procedures and provides an example that demonstrates what happens when they are combined