Difference between UNION and UNION ALL in SQL Server

Jun 18 2012 5:40 AM

Hi friends

I want to know what is the difference between UNION and UNION ALL in SQL Server ?

Thank you.