SQL Server

SQL

SQL Server 2014

1. Create Database
2. SELECT Statement
3. WHERE Clause
4. ALIAS Column
5. ORDER BY Clause
6. TOP Clause
7. SELECT DISTINCT Statement
8. SELECT INTO Statement
9. INSERT INTO SELECT Statement
10. GROUP BY Clause
11. HAVING Clause
12. BULK INSERT Statement
13. SQL Query Builder

SQL Joins

1. CROSS Join
2. FULL Join
3. INNER Join
4. LEFT Join
5. RIGHT Join
6. SELF Join

SQL Operators

1. Arithmetic Operators
2. Comparison Operators
3. AND & OR Operators
4. In Operator
5. BETWEEN Operator
6. LIKE Operator

SQL Built-in Functions

Following are the built-in functions available in T-SQL Server 2014

Aggregate Functions

1. AVG
2. COUNT
3. MAX
4. MIN
5. STDEV
6. STDEVP
7. SUM
8. VAR
9. VARP

Date Functions

1. DATEADD
2. DATEPART
3. DATEDIFF

String Functions

1. CHARINDEX
2. CONCAT
3. LEN
4. LEFT
5. REPLACE
6. REVERSE
7. RIGHT
8. STUFF
9. SUBSTRING
10. UPPER and LOWER Functions

Mathematical Functions

1. ABS
2. ACOS
3. ASIN
4. ATAN
5. ATN2
6. CEILING
7. COS
8. COT
9. FLOOR
10. POWER
11. SIN
12. SQRT
13. SQUARE
14. TAN

Ranking Functions

1. DENSE_RANK
2. NTILE
3. RANK
4. ROW_NUMBER