Dynamic SQL

SQL Server offers a few ways of running a dynamically built SQL statement.  These ways are:

1. Writing a query with parameters
2. Using EXEC
3. Using sp_executesql

For more information see: http://www.mssqltips.com/tip.asp?tip=1160