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
***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]
