You can use a variable as your IN clause, but this requires that you use

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 / guest

Answer Posted / guest

You can use a variable as your IN clause, but this requires
that you use the EXEC function to run the statement.

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is primary key and example?

902

How you can minimize the deadlock situation?

990

What is the full form of dql?

935

How can we use ConnectorJ JDBC Driver with MS SQL?

959

What is truncate table?

902

Why can there be only one clustered index and not more than one?

935

Explain filtered indexes benefits?

958

Why it is recommended to avoid referencing a floating point column in the where clause?

924

What is a heap?

993

Do you know what are the restrictions that views have to follow?

1026

What is difference between standardization and normalization?

1025

Find columns used in stored procedure?

941

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

983

What is a non equi join?

920

What are some examples of schemas?

921