Interested to Buy Any Domain ? << Click Here >> for more details...
What is the disadvantage of using subquery exact after a
select statement?ex.
select (select * from sometable)
- 1 Answers
- 12051 Views
- I also Faced
- E-Mail Answers
Answer Posted / sandeep
Main difference is the outer and inner querries are
independent each other. This executes inner querry for each
and every rows in outer querry. It is better to use joins
instead of sub querries where it is possible. But in some
cases we cud use subquerries
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What is the most common trace flags used with sql server?
What is table valued function and scalar valued functions?
What is the openxml statement in sql server?
Where in ms sql server is ’100’ equal to ‘0’?
Explain syntax for viewing, dropping and disabling triggers?
What is a dbms wizard?
how to invoke a trigger on demand? : Sql server database administration
How can sql server instances be hidden?
What is the report model project?
What do you understand by SQL*Net?
List the different normalization forms?
Explain forward - only cursors?
What is bulkcopy in sql?
Can you explain what are various ways to enhance the ssrs report?
What is the recovery model?
