Learn T-SQL Commands with Samples
Skip Navigation Links
Skip Navigation Links.
Expand DatabaseDatabase
Expand TableTable
Expand ViewView
Expand Stored ProcedureStored Procedure
Expand Data FilteringData Filtering
Expand Data GroupingData Grouping
Expand JoinsJoins
Expand TriggerTrigger
Expand CursorCursor
Expand OperatorsOperators
Expand ConstraintsConstraints
Expand FunctionsFunctions
Expand Conditional ProcessingConditional Processing
Expand LoopingLooping
Expand Error HandlingError Handling
Expand v.IMP Queriesv.IMP Queries
Expand XMLXML
Expand Query PerformanceQuery Performance
Expand QueriesQueries
Expand NormalizationNormalization
Expand CreateCreate
     

T-SQL

 
* Database : Create, Drop, Attach, Detach, Online, Offline, Snapshot, Trigger, Backup Database, etc...

* Table : Create, Alter, Drop, Temp Tables, etc...

* View : Create, Alter, Drop Views, etc...

* Stored Procedure : Create, Alter, Drop SP, etc...

* Data Filtering : Where, In, Not in, Wildcards %, _, [ ], [^ ]

* Data Grouping : Group By, Having, Compute

* Joins : Inner, Left, Right, Full Joins

* Trigger : Create After/Instead Of Trigger, Alter, Drop Trigger, etc...

* Cursor : Fetch Variable, Fetch (First, Next, Last, Prior), Absolute, Relative, Firehose, Monitoring Cursors

* Operators : Arithmetic, Comparison, Logical, Bitwise Operators

* Constraints : Not Null, Unique, Primary Key, Foreign Key, Check, Default Constraints

* Functions : String, Aggregate, Math, Date/Time, Configuration, System Functions

* Conditional Processing : If..Else, Simple Case, Searched Case, GOTO

* Looping : While, While..Break, While..Continue

* Error Handling : Try..Catch

* v.IMP Queries : Find n th Highest Salary, Count and Delete Duplicate Rows, Sort Rows in Specific Order, Generate CSV Values, Rotate Columns into Rows, etc...

* XML : Raw, Auto, Explicit, Path

* Query Performance : How to improve Query Performance with simple Tips

* Queries : Sub Queries, Recursive Queries

* Normalization : Process of organizing Data into Tables and establishing Relationships between them.

* Create : User, Rule, Role, Data Type, etc...