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

Explain datetime2 data type in sal server 2008?

943

What does it mean to normalize data?

992

What is the difference between having clause and where clause in sql server?

1162

What are the parts of a function?

980

What is cross join in sql server joins?

1195

How to use subqueries in the from clause in ms sql server?

1204

What are the character string functions supported by sql server 2005?

1070

How to configure odbc dsn with different port numbers?

1151

What are the requirements to use odbc connections in php scripts?

1154

What are page splits? : SQL Server Architecture

1034

How to implement service broker?

1067

Where are full-text indexes stored?

1036

what stored procedure would you use to view lock information? : Sql server administration

1016

Do you know the capabilities of cursors?

1213

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

1025