SQL Server Tutorials

1. SQL Constraints

2. Primary key and Foriegn key

3. SQL Joins

4. Differences between Truncate and Delete in SQL Server.

5.  Differences between Temparory table and Table Variable in SQL Server.

6. Temporary tables,their types and use with examples in SQL Server.

7. How to find nth highest salary in SQL

8. Instead of Trigger and After Trigger in SQL server

9. CASE usage in SQL Select statements

10. What is the use of SELF JOIN in SQL SERVER with example? 

11. How to join first,middle and last name in Sql Server | Concatenate strings together in Sql Server

12. Index types in SQL Server

13. SQL - Handling NULL values

14. Sql commands and its types

15. How to prevent SQL Injection in Stored Procedures

16. SQL Server Transactions and Error Handling