SQL Server Difference Between Questions List-1

1. Difference between TRUNCATE and Delete?
2. Difference between Clustered Indexes and Non-Clustered Indexes
3. Difference between Primary key and Unique key
4. Difference between Stored Procedures and User Defined Functions
5. Difference between Where and Having clauses
6. Difference between Union and UnionAll
7. Difference between normal Select statement and a Cursor
8. Difference between Instead of Triggers and After Trigges
9. Difference between Views and User-Defined Functions
10. Difference between Triggers and Stored Procedures
11. Difference between Identity and Sequence in SQL Server 2012
12. Difference between Temp table and Table variable
13. Difference between RAISERROR and THROW statements
14. Difference between Local temporary table and Global temporary table
15. Difference between Correlated subquery and Nested subquery
16. Difference between Weak Entity Set and Strong Entity Set
17. Difference between char and varchar data types in Sql Server
18. Difference between Sql Server 2005 and Sql Server 2008
19. Difference between Database Mail and SQL Mail
20. Difference between Azure Table storage and SQL Azure
21. Difference between DBMS and RDBMS
22. Difference between SQL Server 2000 and SQL Server 2005
23. Difference between SQL Server and PostgreSQL
24. Difference between Cross Join and Full Outer Join
25. Difference between SQL Server and Oracle
26. Difference between View and Stored Procedure
27. Difference between IN and EXISTS
28. Difference between Checkpoint and Lazy Writer
29. Difference between Mirroring and Log Shipping
30. Difference between Change Track and Change Data Capture -CDC in SQL Server 2008
31. Difference between Index Rebuild and Index Reorganize in SQL Server 2005
32. Difference between User -defined SP and System-defined SP
33. Difference between Constraints and Triggers
34. Difference between Cast and Convert in SQL Server
35. Difference between CUBE and ROLLUP
36. Difference between VARCHAR and NVARCHAR in SQL Server
37. Difference between SQL Server and MySQL
38. Difference between SET QUOTED_IDENTIFIER ON and SET QUOTED_IDENTIFIER OFF in SQL Server
39. Difference between DateTime and DateTime2 DataType
40. Difference between Stuff function and Replace function
41. Difference between Insert into select and Select into
42. Difference between Pivot and Unpivot
43. Difference between Access and SQL Server
44. Difference between MSDE and SQL Server 2000
45. Difference between Fourth and Fifth Normal Form
46. Difference between Local and Global Cursors
47. Difference between Grant and Revoke statements
48. Difference between All and Any Operators
49. Difference between Push and Pull subscription
50. Difference between Set Rowcount and Top Clause in SQL