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 to define and use table alias names in ms sql server?

1041

What will be query used to get the list of triggers in a database?

953

What is forward - only cursors / read only cursor?

1019

Where is trigger in sql server?

984

Disadvantages of the indexes?

1042

How can you insert null values in a column while inserting the data?

1209

What are the properties of the relational tables?

828

Can an automatic recovery be initiated by a user?

941

Do you know what is openxml in sql server?

1015

How to check parameter value in stored procedure sql server?

909

Why do we use stored procedures in sql server?

892

What is the Main Difference between ACCESS and SQL SERVER?

1062

Explain powershell included in sql server 2008?

996

What is scrollable cursor?

980

Is sql server is free?

919