is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors?
- 2 Answers
- 5033 Views
- I also Faced
- E-Mail Answers
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 to take backup bcp out for a column in table in sql server?
Tell me what is the order in which the sql query is executed?
Explain full-text indexing?
How can you manage sql azure security?
How much memory that we are using in Logshipping Concept?
What is the full meaning of dml?
Is resultset an interface?
How to create an inline table-valued function?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
How will you decide the active and passive nodes?
How do you Implement SSIS Packages in your Project?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
Explain how dts is used to extract, transform and consolidate data?
what method you can use to reduce the overhead of Reporting Services data sources?
