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
Collapse 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
     

Operators

 
* Arithmetic : Perform Mathematical operations on Two expressions of one or more of the data types of the numeric data type category.

* Comparison : : These are used with character, numeric, or date data and can be used in the WHERE or HAVING clause of a query. Comparison operators evaluate to a Boolean data type and return TRUE or FALSE, based on the outcome of the tested condition.

* Logical : The operators AND, OR, and NOT. Used to connect search conditions in WHERE clauses.

* Bitwise : : Perform bit manipulations between two expressions of any of the data types of the integer data type category.

* String Concatenation : Concatenates two strings and sets the string to the result of the operation

* Set Operators : UNION, UNION ALL, EXCEPT, INTERSECT; Combine results from two or more queries into a single result set.