Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5653 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
How to create a dynamic cursor with the dynamic option?
How many types of the database links?
What is bit data type? What's the information that can be stored inside a bit column?
What are the four main query statements?
What is the exact numeric data type in sql?
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Differentiate between mongodb vs. Sql server?
What does ss stand for sexually?
Difference between report and query parameter. Why do we need different type of parameter?
How do I uninstall sql server 2014?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
