SQL Server / TSQL Tutorial

Welcome to our in progress SQL Server / TSQL Tutorial. If you would like us to include any topics, please feel free to let us know by comments or by email.



Chapter 1 (Introduction to SQL Server Management Studio (SSMS)


  1. How to Install SQL Server Management Studio Step by Step
  2. How to Connect to SQL Server Default Instance and Named SQL Server Instances from SSMS
  3. Connect to SQL Server Instance by using Windows Authentication or SQL Server Authentication
  4. How to create shortcut for SSMS and Connect to Default SQL Server Automatically
  5. How to Connect to Several SQL Servers in One Click (Registered Servers Group)
  6. How to Set Status Bar Color in SSMS for Different SQL Server Instances
  7. Configure Start-Up Environment in SQL Server Management Studio (SSMS) 
  8. Cycle Through Clipboard Ring in SQL Server Management Studio (SSMS)
  9. Select and Edit Vertical Blocks in SQL Server Management Studio ( SSMS)
  10. How to create Custom Shortcuts in SQL Server Management Studio ( SSMS)
  11. How to add Line Numbers in SQL Server Management Studio ( SSMS)
  12. How to Change Color and Fonts in SQL Server Management Studio ( SSMS)
  13. How to Split Query Window in SQL Server Management Studio (SSMS)
  14. How to View Multiple Queries and Results Side by Side in (SSMS)
  15. How to Display Query and Results in Separate Tab in (SSMS)
  16. How to use Templates in SQL Server Management Studio (SSMS)
  17. How to Generate DDL Scripts(create) from SQL Server Management Studio (SSMS)
  18. Edit Table Rows / Records  in SQL Server Management Studio ( SSMS)
  19. How to Filter Objects in SQL Server Management Studio (SSMS)
  20. How to Change Values for Edit Top X and Select Top X Rows in SSMS
  21. How to Dock / UnDock Query Windows and Other Tabs in SSMS
  22. How to Handle Multiple Objects by using Object Explorer Detail Windows in SSMS
  23. How to Export query result to .csv or Tab Delimited File in SSMS
  24. How to Uninstall SQL Server Management Studio(SSMS)

Chapter 2: Databases

  1. Use Create Statement to Create Table in SQL Server
  2. How to Alter Table in SQL Server by using Alter Statement
  3. How to rename Column or Table in SQL Server 
  4. How to create Table by using GUI In SQL Server
  5. How to Alter Columns or Generate Alter Scripts by using GUI in SQL Server
  6. How to Add or Drop Column by using GUI in SQL Server
  7. How to Add identity Column to Table by T-SQL and GUI in SQL Server
  8. How To Insert Value In Identity Column Manually in SQL Server Table
  9. How to create Number Table by using Identity Column in SQL Server
  10. How To Reset Identity Column Value in SQL Server Table
  11. How to Drop Identity Property of a Column in SQL Server Table
  12. How to Find all the Tables in a Database which have Identity Column
  13. How to Get Identity Column Values without mentioning Identity Column Name in Select 
  14. How to Add Computed Column in SQL Server Table
  15. How to Generate Drop Table Statement for all the tables in a database
  16. How to Generate Add Column Statement for all the tables in a Database in SQL Server

Chapter 6: Constraints

  1. What are different Types of Constraints Available in SQL Server

6.1 : Not Null Constraint

  1. How to create Not Null Constraint on Column in SQL Server Table
  2. How to Alter Column from Null to Not Null in SQL Server Table
  3. Get List of All Null and Not Null Columns in SQL Server Database

6.2 : Primary Key Constraint

  1. What is Primary Key Constraint in SQL Server Database
  2. How to Get all the Tables which has Primary Key Constraint Created in SQL Server Database
  3. How to get list of Tables without Primary Key Constraint in SQL Server Database 
  4. How to get all the Tables with or without Primary Key Constraint in Sql Server Database
  5. How to get list of Primary Key Constraint from all the databases on SQL Server Instance
  6. Get List of Tables with or without Primary Key Constraint in all Database from SQL Server Instance
  7. How to get list of Tables without Primary Key Constraint in all Databases of SQL Server Instance
  8. How to add Primary Key Constraint to Identity Columns to all the tables in SQL Server Database
  9. How to Rename Primary Key Constraint for Multiple Tables in SQL Server Database
  10. How to drop all Primary Keys from all the tables in SQL Server Database

6.3 : Foreign Key Constraint

  1. How to Create Table with Foreign Key Constraint in SQL Server
  2. How to create Foreign Key Constraint on Multiple Columns in SQL Server Table
  3. How to add Foreign key Constraint to existing table in SQL Server
  4. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint in SQL Server
  5. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint 
  6. Truncate all the tables in a Database in SQL Server ( Drop Foreign Key- Truncate tables-Recreate Foreign Keys)
  7. How to get Parent Table, Reference Table, Foreign Key Constraint Name and Columns in SQL Server
  8. How to drop Foreign Key Constraints in SQL Server Database for all the tables
  9. How to generate scripts to Re-Generate Foreign Key Constraints in SQL Server Database
  10. Could not drop object because it is referenced by a FOREIGN KEY constraint
  11. How to Drop Foreign Key Constraint in SQL Server Database
  12. The UPDATE statement conflicted with the REFERENCE constraint
  13. How to disable all Foreign Key Constraint in SQL Server Database
  14. How to Generate Script To Enable All Foreign Key Constraints in SQL Server Database
  15. How to create Foreign Key Constraint With ON UPDATE CASCADE in SQL Server
  16. How to create Foreign Key Constraint with ON DELETE CASCADE in SQL Server
  17. How to Create Foreign Key Constraint with ON DELETE SET NULL Option in SQL Server 

6.4 : Check Constraint

  1. What is Default Constraint in SQL Server
  2. How to add Default Constraint to existing Columns in SQL Server Table
  3. How to List all Default Constraints with Columns in SQL Server Database
  4. How to rename all Default Constraints according to Naming Standards or naming Convention in SQL Server
  5. How to drop all Default Constraints in SQL Server Database
  6. How to generate Scripts to Add Default Constraints to Column in Multiple Tables in SQL Server Database

6.6 : Unique Constraint

Chapter 7 : Insert Row/s in SQL Server Table

9.1 Logical Operators



Cursors