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
- 4978 Views
- I also Faced
- E-Mail Answers
Answer Posted / kishor kumar
It is possible by using Dynamic SQL.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
If user is owning any SQL Objects, can we drop that user
What is BLOCK statements in SQL?
How to connect php with different port numbers?
What is the difference between a clustered index and a non-clustered index?
How to create hyperlink from returned sql query ?
Do you know what is user defined datatypes and when you should go for them?
Where views are stored in sql server?
how to create “alternate row colour”?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How to list all triggers in the database with sys.triggers in ms sql server?
Explain what is the difference between union and union all?
How to rename an existing column with sql server management studio?
Please illustrate physical database architecture? : SQL Server Architecture
How do you rebuild an identity column?
What are the steps you can take to avoid “deadlocks”?
