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 debug a stored procedure in sql server?
What is factless fact table? : sql server analysis services, ssas
Mention what are the core components of ssrs?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
Explain optimistic and pessimistic concurrency?
How to see existing views in ms sql server?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
Do you know what is xpath?
What are relationships and mention different types of relationships in the dbms
How to call stored procedure using http soap?
What happens when the SQL Azure database reaches Max Size?
Can two tables share the same primary key?
What is the rdl file?
Can We Use Data-grids For Our Report In Ssrs?
Can sql servers linked to other servers like oracle?