You can use a variable as your IN clause, but this requires that you use

is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors?

Question Posted / guest

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

Please Help Members By Posting Answers For Below Questions

How do you improve the performance of a SQL Azure Database?

129

What is difference between Datepart() and Datename() in SqlServer?

902

What does ss stand for sexually?

794

What is indexed view? How to create it?

759

What are different types of constraints?

694

What is constraints and its types?

676

Explain what are the restrictions while creating batches in sql server?

797

How would you add a section to a table?

777

Why would you call update statistics?

756

Do you know the cursor optimization tips?

744

What is sql server used for?

729

What is create command?

700

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

721

What function does a database engine serve in the sql server?

762

What are the lambda triggers?

656