Differences in SQL

1. UNION And UNION ALL

2. DELETE And TRUNCATE

3. STUFF And REPLACE

4. JOIN And APPLY

5. Temporary Table And Table Variable

6. SET And SELECT

7. Rank () And Dense_Rank()  And Row_Number

8. Log Shipping And Mirroring

9. Where And Having