|
|
|
|
| SQL Server / T-SQL Home |
|
|
Select Query
|
| ALL ( 1 ) | AND ( 1 ) | ANY ( 1 ) | AS ( 3 ) | Between AND ( 5 ) | Case ( 9 ) |
| Column Alias ( 4 ) | Compare Date ( 2 ) | Data Type ( 1 ) | Date Calculation ( 1 ) | Date Compare ( 1 ) | DESC ( 1 ) |
| DISTINCT ( 3 ) | EXISTS ( 5 ) | Group BY ( 9 ) | HAVING ( 5 ) | IN ( 6 ) | IS NULL ( 2 ) |
| ISNULL ( 5 ) | LIKE ( 9 ) | Logical Operator ( 6 ) | MAXRECURSION ( 1 ) | NOT ( 4 ) | NULL ( 2 ) |
| Operator Precedence ( 2 ) | OR ( 2 ) | Order Columns ( 3 ) | Order ( 11 ) | Query Batch ( 1 ) | Query Columns ( 6 ) |
| Quotation Mark ( 1 ) | Select Into ( 3 ) | Select ( 13 ) | String Compare ( 1 ) | Top percent ( 4 ) | Top With Ties ( 1 ) |
| Top ( 6 ) | Where ( 8 ) | With ( 2 ) |
|
Subquery
|
| Correlated subquery ( 4 ) | Nested Subquery ( 1 ) | RTRIM ( 4 ) | Subqueries ALL ( 1 ) | Subqueries ANY ( 2 ) | Subqueries Exists ( 4 ) |
| Subqueries IN ( 5 ) | Subqueries ( 4 ) | Subquery Aggregate Functions ( 2 ) | Subquery From ( 1 ) |
|
Insert Delete Update
|
| Batch Insert ( 2 ) | Delete ( 6 ) | Insert Image ( 1 ) | Insert Select ( 4 ) | Insert ( 2 ) | Update ( 12 ) |
|
Data Set
|
| EXCEPT ( 1 ) | INTERSECT ( 1 ) | UNION ALL ( 1 ) | Union ( 3 ) |
|
Store Procedure Function
|
| Create Function ( 5 ) | Create Procedure ( 10 ) | Default Parameter ( 2 ) | Drop Procedure ( 1 ) | EXEC ( 1 ) | EXECUTE ( 2 ) |
| Function Call ( 1 ) | Function Parameters ( 1 ) | Function Return ( 7 ) | Scalar Functions ( 1 ) |
|
Transact SQL
|
| Assign Value ( 4 ) | ATAN ( 1 ) | Break ( 2 ) | COALESCE ( 1 ) | Code Block ( 2 ) | Continue ( 2 ) |
| Data Insert ( 2 ) | Declare Variables ( 4 ) | Error ( 3 ) | Handle Error ( 1 ) | If ( 6 ) | Insert Data ( 6 ) |
| LOG ( 2 ) | Object Property ( 1 ) | Print ( 1 ) | Query Data ( 2 ) | RAISERROR ( 2 ) | RowCount ( 3 ) |
| schemas ( 1 ) | Select Data ( 1 ) | Select Variables ( 1 ) | Set Variables ( 3 ) | Statement ( 1 ) | Table Variable ( 1 ) |
| Update Data ( 5 ) | Variable Scope ( 2 ) | Variables ( 1 ) | Version ( 1 ) | While ( 1 ) | |
|
Trigger
|
| Create Trigger ( 3 ) | Disable Trigger ( 1 ) | Insert Trigger ( 1 ) | Trigger Value ( 2 ) | Update Trigger ( 2 ) |
|
Table
|
| Add Column ( 2 ) | Alter Table ( 1 ) | Column Data Type ( 1 ) | Column Index ( 1 ) | Computed Column ( 2 ) | Copy Data ( 1 ) |
| Create Table ( 1 ) | Derived Columns ( 1 ) | Drop Column ( 2 ) | Drop Table ( 2 ) | Rename Column ( 1 ) | Rename Table ( 1 ) |
| Sub query ( 2 ) | Table Alias ( 1 ) | Table Copy ( 1 ) | Table Existence ( 1 ) | Table Properties ( 1 ) | Temporary Table ( 3 ) |
| TRUNCATE TABLE ( 2 ) |
|
Table Joins
|
| ANSI Join Syntax ( 3 ) | Cross Join ( 3 ) | INNER JOIN ( 4 ) | Left Join ( 2 ) | LEFT OUTER JOIN ( 1 ) | RIGHT JOIN ( 1 ) |
| RIGHT OUTER JOIN ( 2 ) | SQL Server Join Syntax ( 2 ) | Table Join ( 10 ) |
|
View
|
| Alter View ( 1 ) | Create View ( 13 ) | Drop View ( 1 ) | ENCRYPTION ( 1 ) | Nested View ( 1 ) | Query View ( 1 ) |
| SCHEMABINDING ( 1 ) | Updatable View ( 1 ) | View Existance ( 1 ) |
|
Index
|
| CLUSTERED INDEX ( 1 ) | Create Index ( 6 ) | DROP EXISTING ( 1 ) |
|
Database
|
| Create Database ( 3 ) | Database Info ( 1 ) | Database Option ( 7 ) | databases ( 2 ) | USE ( 1 ) |
|
Transaction
|
| Commit Transaction ( 3 ) | Transaction Roll back ( 4 ) |
|
Cursor
|
| Declare CURSOR ( 1 ) | Fetch Data ( 1 ) | Fetch Status ( 1 ) |
|
Constraints
|
| Add Primary Key ( 2 ) | CASCADE ( 1 ) | Check Options ( 1 ) | Check value range ( 1 ) | Column Constraints ( 5 ) | Constraints Basics ( 2 ) |
| Default Value ( 2 ) | Foreign Key ( 2 ) | Maintain Constaints ( 1 ) | Primary key ( 3 ) | Range Check ( 1 ) | Unique ( 1 ) |
|
Sequence
|
| IDENTITY ( 11 ) | IDENTITYCOL ( 1 ) | NEWID ( 1 ) | Procedure Call ( 3 ) | Procedure Existance ( 1 ) | Procedure Permission ( 1 ) |
| Procedure with Parameters ( 13 ) | Procedure ( 1 ) |
|
Data Type
|
| Bit ( 1 ) | Cast ( 15 ) | Convert ( 2 ) | Data Type Convert ( 1 ) | decimal ( 5 ) | float ( 1 ) |
| Money ( 1 ) | nchar Data Type ( 1 ) | Number Format ( 2 ) | varchar ( 1 ) |
|
Date Timezone
|
| Date Data Type ( 2 ) | Date Format ( 12 ) | DATEADD ( 14 ) | DATEDIFF ( 15 ) | DATENAME ( 3 ) | DATEPART ( 8 ) |
| Datetime ( 2 ) | Day ( 3 ) | GetDate ( 3 ) | GETUTCDATE ( 2 ) | Int ( 1 ) | Month ( 3 ) |
| Year ( 3 ) |
|
Aggregate Functions
|
| Aggregate Function Basics ( 2 ) | Count ( 4 ) | COUNT BIG ( 2 ) | MAX ( 2 ) | MIN ( 2 ) |
|
Analytical Functions
|
| AVG ( 3 ) | COMPUTE ( 5 ) | DENSE RANK ( 2 ) | NTile ( 1 ) | Over ( 1 ) | RANK ( 2 ) |
| Row Number ( 3 ) | STDEV ( 4 ) | SUM ( 2 ) | VAR ( 2 ) | VARP ( 2 ) | WITH ROLLUP ( 2 ) |
|
Math Functions
|
| ABS ( 2 ) | ACOS ( 2 ) | ASIN ( 1 ) | CEILING ( 3 ) | COS ( 2 ) | COT ( 1 ) |
| Cube ( 1 ) | DEGREES ( 2 ) | EXP ( 1 ) | FLOOR ( 3 ) | Log10 ( 2 ) | mod ( 1 ) |
| PI ( 1 ) | Power ( 2 ) | RADIANS ( 1 ) | RAND ( 1 ) | ROUND ( 4 ) | SIGN ( 1 ) |
| SIN ( 1 ) | SQRT ( 1 ) | SQUARE ( 1 ) | TAN ( 1 ) |
|
String Functions
|
| ASCII ( 2 ) | CHAR ( 3 ) | CHARINDEX ( 5 ) | DATALENGTH ( 3 ) | Difference ( 3 ) | Escape ( 1 ) |
| LEFT ( 4 ) | LEN ( 4 ) | Lower ( 2 ) | LTRIM ( 2 ) | NCHAR ( 2 ) | PATINDEX ( 2 ) |
| QUOTENAME ( 1 ) | Regular Expressions ( 5 ) | REPLACE ( 3 ) | REPLICATE ( 3 ) | REVERSE ( 2 ) | RIGHT ( 4 ) |
| SOUNDEX ( 2 ) | Space ( 2 ) | STR ( 6 ) | STUFF ( 2 ) | Substring ( 4 ) | UNICODE ( 1 ) |
| UPPER ( 3 ) |
|
System
|
| columns ( 1 ) | QUOTED IDENTIFIER ( 1 ) | Row Count ( 2 ) | SHOWPLAN TEXT ( 2 ) | sp helptext ( 1 ) | sys.types ( 1 ) |
| sys.views ( 1 ) | syscomments ( 1 ) | sysmessages ( 2 ) | sysobjects ( 1 ) | views ( 1 ) |