Tag: Passing parameters to dynamic query

Passing parameters to dynamic query

visit https://zonixsoft.com (our official Website)   Consider following queries 1. SELECT * FROM @tablename 2. SELECT @colname FROM tbl 3. SELECT * FROM tbl WHERE x IN (@list) 4. SELECT @Cnt=Count(*) FROM tbl WHERE x IN (@list)   For the first query, it will give error ‘Must declare the table variable “@tablename”‘ if @tablename is […]