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
How do I find the transaction log size in sql server?
Explain Geography datatype in SQL Server
What is updatable resultset?
What is molap and its advantage? : sql server analysis services, ssas
How to see existing views in ms sql server?
Can I delete event logs?
What happens if null values are involved in string operations?
Explain what is analysis service repository?
What have included columns when we talk about sql server indexing?
How to add additional conditions in SQL?
Can group by and orderby be used together?
What is collation sensitivity?
What is the cpu pressure?
What is the importance of concurrency control?
Can sql servers linked to other servers?