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 are the steps to process a single select statement?

942

Where can you add custom error messages to sql server?

1123

What are the limitations/drawbacks or ssrs 2008 r2?

139

What is query and its types?

915

What is difference between delete and truncate commands?

1083

how to take backup bcp out for a column in table in sql server?

2105

How do you delete a data source?

1007

What does Master database contains?

1136

List few advantages of stored procedure.

981

What are the different types of locks in the database?

925

Explain view in sql server?

1055

can a database be shrunk with users active? : Sql server administration

1009

What happens when unicode strings concatenate with non-unicode strings?

1094

Can sql servers linked to other servers like oracle?

953

Explain what you mean by 3 tier architecture.

1077