| Stored Procedure | Functions | View – Virtual Table |
| Trigger | Index - Clustered, Non-clustered | Cursor |
| Joins | Error Handling - TRY CATCH | @@ERROR |
| RAISERROR | @@ROWCOUNT | @@IDENTITY |
| SQL Select Query | |||
| ALL | AND | ANY | AS |
| COALESCE | Between Operator | Case | Column Alias |
| Compare Date | Data Type | Date - DATEDIFF | Date Compare |
| DESC | DISTINCT | EXISTS | Group BY |
| HAVING | NOT EXISTS | IS NULL | ISNULL |
| LIKE | Logical Operator | Math Operator | MAXRECURSION |
| NOT | NULL | Operator Precedence | OR |
| Order Columns | Order | Query Batch | Query Columns |
| Quotation Mark | SELECT INTO | SELECT | String Compare |
| Top Percent | Top With Ties | Top | Where |
| With | |||
SQL Sub Query | |||
| Correlated sub query | Nested Sub query | RTRIM | Sub queries ALL |
| Sub queries ANY | Sub queries Exists | Sub queries IN | Sub queries |
| Sub query Aggregate Functions | Sub query From | ||
| SQL Insert Delete Update | |||
| Batch Insert | BULK INSERT | Delete | Insert Image |
| Insert Select | Insert | Update | |
SQL Data Set | |||
| EXCEPT | INTERSECT | UNION ALL | Union |
|
Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..
|