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
How can you ensure that the database and sql server based application perform well?
Does index speed up select statements?
How to send email from database?
What is the contrast amongst drop and truncate?
What is the template in sql?
What is an expression in ms sql server?
What is difference in performance between insert top (n) into table and using top with insert?
Describe different Processing Modes offered by SSRS?
How to bind a view to the schema of the underlying tables?
Do you know what is blocking?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What are the different types of locks in the database?
How to drop an existing stored procedure in ms sql server?
What is the recovery model? List the types of recovery model available in sql server?
What are the transaction properties?