C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




difference between UNION ALL Statement and UNION


Posted Date: 18 Sep 2008    Resource Type: Definitions    Category: General

Posted By: prasanthkumar       Member Level: Gold
Rating:     Points: 3




The main difference
* UNION All statement---- is much faster than UNION,
Reason:
==============

UNION ALL statement does not look for duplicate rows.

UNION statement does look for duplicate rows, whether or not they exist.




Responses


No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks      
Popular Tags   What are tags ?   Search Tags  
Difference between UNION ALL Statement and UNION  .  

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: What are the Similarities between Classes and Structures?
Previous Resource: Office Business Applications
Return to Discussion Resource Index
Post New Resource
Category: General


Post resources and earn money!
 
Related Resources



dotNet Slackers   BizTalk Adaptors    Web Design

email fax service

Contact Us    Privacy Policy    Terms Of Use