It is possible by using Dynamic SQL.

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 / kishor kumar

Answer Posted / kishor kumar

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a join in sql?

1068

How to link tables in sql server?

911

What is triggers in ms sql server?

1092

How many columns can exist together per table?

1139

What is the maximum rows in sql server table?

895

What is GUID in sql server?

1144

Explain security with sql azure?

186

What happens if you delete a table that is used by a view?

973

Explain trigger and its types?

1050

What is 3nf normalization form?

1084

Do you know what are the reporting services components?

957

How to run queries with sql server management studio express?

1070

Difference between Inner vs outer joins?

928

Difference between Sql server reporting services and Crystal reports?

168

What are the different SQL Server Versions you have worked on?

988