[SQL ] The Curse and Blessings of Dynamic SQL

By | Y2014Y2014-8M-D

cite from: http://www.sommarskog.se/dynamic_sql.html

An SQL text by Erland Sommarskog, SQL Server MVP. Latest revision: 2011-06-23.

An earlier version of this article is also available in German. Translations provided by SQL Server MVP Frank Kalis.

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)
…(omit the rest)

1,321 total views, 4 views today

댓글 남기기