What are sub-queries? Give example? In which case
sub-queries are not feasible?
- 4 Answers
- 10324 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / akhil
text and image datatypes are not allowed in
subqueries.Subqueries cannot manipulate their results
internally, that is, a subquery cannot include the order by
clause, the compute clause, or the into keyword.
Correlated (repeating) subqueries are not allowed in the
select clause of an updatable cursor defined by declare cursor.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to turn off warning messages during php execution?
What is a coalesce function?
Define self join?
When I run the sql server 2000 setup, it just hangs. What do I do?
What are synonyms?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
What are the advantages dts has over bcp?
What is a bit datatype?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What are the disadvantages of merge replication?
How many types of the database links?
How do I run a trace in sql server?
what is an index? : Sql server database administration
How can I check if a view exists in a sql server database?
How do I start and stop sql server?
