What is a dynamic SQL query, and when would I want to use one? I'm using SQL Server 2005.

sql sql-server-2005 dynamic-sql
Edit
Report