Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is stored procedures?

954


Can you move the resources after pausing the node? : sql server database administration

1041


What are the basic features of a trigger in ms sql server?

1108


What is the difference between grant and with grant while giving permissions to the user?

897


What is plan freezing?

909


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.

2879


What are the default system databases in sql server 2000?

961


Define msdb database?

972


How to remove duplicate rows from table except one?

938


What are the new features are introduced in sql server 2012 reporting services?

143


How do you Implement SSIS Packages in your Project?

1869


Explain transaction server auto commit?

987


What is amo? : sql server analysis services, ssas

1043


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

892


What is 5nf in normalization form?

933