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

How to find related tables in sql server?

870

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

927

Explain an automatic checkpoint

908

Name the different type of indexes in sql?

906

Explain indexed views and partitioned view with their syntax.

1076

Is sql server difficult to learn?

862

What is the difference between truncate and delete commands?

996

What is the difference between nvl and nvl2?

897

How do I manually uninstall an instance of sql server 2016?

959

What are the disadvantages of indexes?

994

How to list all field names in the result set using mssql_field_name()?

867

what are the different stages of Report Processing?

125

Tell me about pre-defined functions of sql?

1071

Explain concepts of analysis services?

890

What are the different types of columns types constraints in the sql server?

1004