TSQL Tutorial

Welcome to SQL Tutorial!

SQL BasicSQL AdvancedSQL AdvancedSQL Functions
SQL Select
SQL Distinct
SQL Where
SQL And - OR
SQL Order By
SQL Group By
SQL Having
SQL Like
SQL Insert
SQL Update
SQL Delete
SQL Join
SQL Inner Join
SQL Left Join
SQL Right Join
SQL Full Join
SQL Union
SQL TOP
SQL Wildcard
SQL IN
SQL Between
SQL ISNULL
SQL Create Database
SQL Create Table
SQL Create Index
SQL Create View
SQL Increment
SQL Drop
SQL Alter Table
SQL Add Column
SQL Alter Column
SQL Rename Column
SQL Drop Column
SQL Avg
SQL Count
SQL Max
SQL Min
SQL Sum
SQL Mid
SQL Len
SQL Round
SQL Now
SQL UCase
SQL LCase

SQL examples
SQL Aggregate functions
Difference between Union and Union All
Difference between Char and Varchar
Difference between Delete and Truncate
Difference between Inner Join and Outer Join
Difference between Where and Having
Difference between Varchar and Nvarchar