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
- 5439 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 secure is sql server database?
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.
How will you monitor replication latency in transactional replication? : sql server replication
Can a table have 2 primary keys?
Explain an automatic checkpoint
What do you understand by hotfixes and patches in sql server?
What are the different types of cursor?
What are the different types of replication? How are they used?
what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?
where do you use Isolations?give me some exmpale?
What is abstracting periodical?
Explain the difference between cross join and full outer join?
-
Oracle (3259) - 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)
