If we use where clause in the left outer join then how the
query would behave/act?
Answer Posted / prabir4prabir
It will act as a inner join.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is dbcc updateusage?
Explain foreign key in sql server?
Explain transaction server consistency?
How many levels of sp nesting is possible?
What is the function of inner join?
Is it important for a database administrator to understand the operating system and file access?
Explain triggers in sql?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What are different backups available in sql server?
Explain acid?
How to rename databases in ms sql server?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
Can two tables share a primary key?
What is the cpu pressure?
How many types of attribute relationships are there? : sql server analysis services, ssas