is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I find the transaction log size in sql server?

513


Explain Geography datatype in SQL Server

627


What is updatable resultset?

514


What is molap and its advantage? : sql server analysis services, ssas

545


How to see existing views in ms sql server?

541






Can I delete event logs?

541


What happens if null values are involved in string operations?

552


Explain what is analysis service repository?

534


What have included columns when we talk about sql server indexing?

572


How to add additional conditions in SQL?

582


Can group by and orderby be used together?

593


What is collation sensitivity?

549


What is the cpu pressure?

562


What is the importance of concurrency control?

663


Can sql servers linked to other servers?

545