Answer Posted / g.ramesh
Outter Join Produce result set,which contain matched rows
and has well has unmatched rows.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is the sql server 2000 version number?
What is the contrast between sql and pl/sql?
What happens if null values are involved in boolean operations?
Can you import Microsoft Excel data to SSRS?
Difference between uniqe index and uniqe constraint?
Explain different types of collation sensitivity?
Tell me what is the order in which the sql query is executed?
What are the steps you should follow to start sql server in single-user mode?
What does null mean?
What is sql server management studio? : sql server management studio
How many non clustered indexes there can be on table ?
What is an expensive query?