The Curse and Blessings of Dynamic SQL

Introduction If you follow the various newsgroups on Microsoft SQL Server, you often see people asking why they can’t do: SELECT * FROM @tablename SELECT @colname FROM tbl SELECT * FROM tbl WHERE x IN (@list) For all three examples you can expect someone to answer Use dynamic SQL and give a quick example on […]