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 stored procedures?
Can you move the resources after pausing the node? : sql server database administration
What are the basic features of a trigger in ms sql server?
What is the difference between grant and with grant while giving permissions to the user?
What is plan freezing?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What are the default system databases in sql server 2000?
Define msdb database?
How to remove duplicate rows from table except one?
What are the new features are introduced in sql server 2012 reporting services?
How do you Implement SSIS Packages in your Project?
Explain transaction server auto commit?
What is amo? : sql server analysis services, ssas
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What is 5nf in normalization form?