Define MSSQL

SQL Data Types

SQL Commands

SQL Create Database

SQL Create Table

SQL Insert Into

SQL Select Query

SQL Orderby

SQL Update Command

Truncate Delete Drop

SQL Select Top

SQL Constraints

SQL Alias

SQL Joins

SQL Union, intersect

SQL Select Into

SQL Insert Into Select

SQL Indexes

SQL Alter Table

SQL AutoIncrement

SQL View

SQL Date Functions


SQL Aggregate Functions

SQL Group By

SQL Scalar functions

Stored Procedure

MS-SQL Commands

SQL commands can be classified into groups based on their nature:
DDL - Data Definition Language:

CreateCreates a new table, a view of a table, or other object in database
AlterModifies an existing database object, such as a table.
DropDeletes an entire table, a view of a table or the database.

DML - Data Manipulation Language:

SelectRetrieves certain records from one or more tables
InsertCreates a record
UpdateModifies records
DeleteDeletes records

DCL - Data Control Language:

Command Description
Grant Gives a privilege to user
Revoke Takes back privileges granted from user