SQL Commands

SQLCommands

Kindly refer following SQL Commands, I have covered most commonly used commands and I will  keep adding when new SQL commands are added to new version of SQL Server and respectively deprecated commands will be removed from the list. You can also request to add more commands which are not available in the list and if you want to use it.

SQL Commands

SQL SELECTSQL DISTINCTSQL WHERESQL AND
SQL CREATE TABLESQL ORDER BYSQL SELECT TOPSQL OR
SQL ALIASESSQL INSQL BETWEENSQL NOT BETWEEN
SQL UPDATESQL INSERT INTOSQL SELECT INTOSQL DELETE
SQL NOT NULLSQL LIKESQL GROUP BYSQL HAVING
SQL JOINSSQL INNER JOINSQL RIGHT JOINSQL LEFT JOIN
SQL FULL JOINSQL CROSS JOINSQL UNIONSQL UNION ALL
SQL DEFAULTSQL PRIMARY KEYSQL FOREIGN KEYSQL CHECK
SQL UNIQUESQL ALTERSQL DROPSQL CREATE DB
SQL IDENTITYSQL CONSTRAINTSSQL DATA TYPESSQL CREATE INDEX
SQL VIEWSSQL WILDCARDSQL NULL

***Right Click Here and Open Link in New Tab to watch live practicals for SQL COMMANDS.

 

SQL Functions

SQL LEFT()SQL RIGHT()SQL AVG()SQL COUNT()
SQL MIN()SQL MAX()SQL SUM()SQL UPPER()
SQL LOWER()SQL MID()SQL LEN()SQL ROUND()
SQL IIF()SQL FORMAT()SQL SQRT()SQL RAND()
SQL CONCAT()SQL LAG()SQL LEAD()SQL CHOOSE()
SQL SQUARE()SQL LTRIM()SQL RTRIM()SQL REPLACE()
SQL CONCAT()SQL REVERSE()SQL SPACE()

Reference: Manzoor Siddiqui [www.SQLServerLog.com]