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

What is difference between rownum and rowid?

902

What is a recursive stored procedure in sql server?

1175

Why is normalisation important?

942

What is attribute hierarchy? : sql server analysis services, ssas

1018

What are the authentication modes in sql server? How can it be changed?

1128

Can we shrink data file in sql server?

1049

Explain Geography datatype in SQL Server

1128

What is SQL Azure Fabric?

110

What’s the use of custom fields in report?

944

How do I find the query plan in sql server?

957

is there a column to which a default can't be bound? : Sql server database administration

1015

What is a database table?

970

What are the Advantages of using CTE in sql server?

1119

Why do you want to join software field as you have done your BE in Electronics?

2144

Explain having clause and where clause?

1055