SQL Data Types

(SQL Numeric data types, Date and Time data types, Character and String data types, Unicode character string data types, Binary data types, and miscellaneous data types.)

​

SQL Operators

(SQL Arithmetic Operators, Comparison Operators, Logical Operators, and Bitwise Operators)

SQL Expressions

(SQL Boolean Expression, SQL Numeric Expression, and SQL Date Expression)

SQL Comments

(SQL Comments, Comments are used to explain sections of SQL statements, or to prevent the execution of SQL statements. Single-Line Comments, and Multi-line Comments)

Single-line comment

Multiple-line comment

Variables

Built-in Global Variables

@@IDENTITY

Flow Control

IF – ELSE

WHILE

CASE

SQL – Data Definition Language Commands and Operations.

(SQL Data Definition Language Commands, Create, Alter, Drop, Truncate, and Rename.

Data Definition Language  Operations, Create a Database, Use Database, Rename a Database, Drop Database, Create a Table, Rename Table, Add a Column to exiting Table, Add multiple columns to existing Table, Modify an existing column, Rename a Column, Drop a Column, Truncate a Table, and Drop a Table.)

SQL – Data Manipulation Language Commands and Operations

(Data Manipulation Language Commands, SELECT, INSERT, UPDATE, and DELETE.

Data Manipulation Language Operations, Retrieving data from a table, inserting data into a table, updating existing data into a table, and deleting all records from a table.)