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

Functions

 
* String Functions : perform operations on character or binary Strings. Built-in string functions return values commonly needed for operations on character Data.

* Aggregate Functions : perform a Calculation on a set of values and return a single value. Except for COUNT, aggregate functions ignore null values.

* Math Functions : perform a calculation, usually based on input values that are provided as arguments, and return a numeric value.

* Date and Time Functions : perform an operation on a Date and Time input value and return a String, Numeric, or Date and Time value.

* Configuration Functions : Return Information about current configuration option settings.

* System Functions : A set of built-in functions that perform operations on and return the information about values, objects, and settings in SQL Server.