is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors?
Answer Posted / 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 |
Post New Answer View All Answers
What is trigger in salesforce?
What is query cost in sql server?
What is the importance of concurrency control?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
Explain differentiate between a having clause and a where clause?
How are the exceptions handled in sql server programming?
What happens if an integer is too big for int date type?
When cursors are useful?
How to find related tables in sql server?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Why is normalisation important?
What purpose does the model database server?
What is the purpose of a table?
Can a function call a stored procedure in sql server?
How to find index size for each index on table?