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

When you use @@error and try-catch?

1037

What is a primary index?

919

How to get the number of affected rows?

996

How do I port a number to sql server?

1029

When to use Inner join & when to use subquery?

1150

Determine when to use stored procedure to complete sql server tasks?

1045

Why de-normalization required?

995

Why should you use or avoid select * statements?

1015

How many types of objects are there?

996

How to change the ownership of a schema in ms sql server?

1176

What is rs.exe utility?

156

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2060

How do I start sql server 2017?

928

What does truncate do?

933

How to provide default values to function parameters?

1125