Generate dynamic SQL statements in SQL Server
Posted March 11th, 2008 by Andrew PopoffA dynamic SQL statement is constructed at execution time, for which different conditions generate different SQL statements. It can be useful to construct these statements dynamically when you need to decide at run time what fields to bring back from SELECT statements; the different criteria for your queries; and perhaps different tables to query based on different conditions.
Read more
Tags: dynamic SQL statements |
Leave a Reply