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


Please Help Members By Posting Answers For Below Questions

How can you ensure that the database and sql server based application perform well?

819


Does index speed up select statements?

772


How to send email from database?

780


What is the contrast amongst drop and truncate?

779


What is the template in sql?

754


What is an expression in ms sql server?

759


What is difference in performance between insert top (n) into table and using top with insert?

763


Describe different Processing Modes offered by SSRS?

204


How to bind a view to the schema of the underlying tables?

782


Do you know what is blocking?

743


what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

758


What are the different types of locks in the database?

672


How to drop an existing stored procedure in ms sql server?

753


What is the recovery model? List the types of recovery model available in sql server?

683


What are the transaction properties?

770