| SQL Server / T-SQL |
| 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 ) |