is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors?
Answers were Sorted based on User's Feedback
Answer / guest
You can use a variable as your IN clause, but this requires
that you use the EXEC function to run the statement.
| Is This Answer Correct ? | 2 Yes | 1 No |
How to create database with physical files specified in ms sql server?
How do I know if localdb is running?
What is fill factor and pad index?
What triggers long term care?
Explain powershell included in sql server 2008?
What is a non clustered primary key?
What is the difference between for trigger and after trigger?
Describe the left outer join & right outer join. : sql server database administration
Which command displays the SQL command in the SQL buffer, and then executes it?
How to use old values to define new values in update statements in ms sql server?
what stored procedure can you use to display the current processes? : Sql server administration
When a primary key constraint is included in a table, what other constraints does this imply?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)