# TSQL [Home](/rezoom-sql/master.md) > [Language](/rezoom-sql/language.md) > [Functions](/rezoom-sql/language/functions.md) > TSQL [← SQLite](/rezoom-sql/language/functions/sqlitefunctions.md) | [Postgres →](/rezoom-sql/language/functions/postgresfunctions.md) ## T-SQL functions This is the complete list of built-in functions supported by the `"tsql"` backend. ### abs ``` abs( a^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### acos ``` acos(^) -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### ascii ``` ascii(STRING^) -> INT ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### asin ``` asin(^) -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### atan ``` atan(^) -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### atn2 ``` atn2(^, ^) -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### avg ``` avg( a) -> a? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### ceiling ``` ceiling( a^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### char ``` char(^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### charindex ``` charindex(STRING^, STRING^, {0..1}) -> ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### choose ``` choose(^, a^{0..*}) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### coalesce ``` coalesce(a?, a?{0..*}, a^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### concat ``` concat(STRING, STRING, STRING{0..*}) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### concat\_ws ``` concat_ws(STRING^, , , {0..*}) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### cos ``` cos(^) -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### cot ``` cot(^) -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### count ``` count() -> INT ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### count\_big ``` count_big() -> INT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### current\_timestamp ``` current_timestamp() -> DATETIME ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### cursor\_rows ``` cursor_rows() -> INT ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### datalength ``` datalength(STRING^) -> ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### dateadd ``` dateadd(STRING, ^, DATETIME^) -> DATETIME ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### datediff ``` datediff(STRING, DATETIME^, DATETIME^) -> INT ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### datediff\_big ``` datediff_big(STRING, DATETIME^, DATETIME^) -> INT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### datefirst ``` datefirst() -> INT8 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### datefromparts ``` datefromparts(^, ^, ^) -> DATETIME ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### datename ``` datename(STRING, DATETIME^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### datetime2fromparts ``` datetime2fromparts(^, ^, ^, ^, ^, ^, ^, ^) -> DATETIME ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### datetimefromparts ``` datetimefromparts(^, ^, ^, ^, ^, ^, ^) -> DATETIME ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### datetimeoffsetfromparts ``` datetimeoffsetfromparts(^, ^, ^, ^, ^, ^, ^, ^, ^, ^) -> DATETIMEOFFSET ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### day ``` day(DATETIME^) -> ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### dbts ``` dbts() -> BINARY ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### degrees ``` degrees( a^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### difference ``` difference(STRING^, STRING^) -> INT ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### exp ``` exp(^) -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### fetch\_status ``` fetch_status() -> INT ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### floor ``` floor( a^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### format ``` format(^, STRING^, STRING^{0..1}) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### getdate ``` getdate() -> DATETIME ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### getutcdate ``` getutcdate() -> DATETIME ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### grouping ``` grouping() -> INT8 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### grouping\_id ``` grouping_id({0..*}) -> INT ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### identity ``` identity() -> ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### iif ``` iif(BOOL, a^, a^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### impure ``` impure(a^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | yes | no | ### isjson ``` isjson(STRING^) -> BOOL ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### json\_modify ``` json_modify(STRING^, STRING^, STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### json\_query ``` json_query(STRING^, STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### json\_value ``` json_value(STRING^, STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### langid ``` langid() -> INT8 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### language ``` language() -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### left ``` left(STRING^, ^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### len ``` len(STRING^) -> ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### lock\_timeout ``` lock_timeout() -> INT ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### log ``` log(^, ^{0..1}) -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### log10 ``` log10(^) -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### lower ``` lower(STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### ltrim ``` ltrim(STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### max ``` max(a) -> a? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### max\_connections ``` max_connections() -> INT ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### max\_precision ``` max_precision() -> INT8 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### min ``` min(a) -> a? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### month ``` month(DATETIME^) -> ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### nchar ``` nchar(^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### nestlevel ``` nestlevel() -> INT ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### nullable ``` nullable(a?) -> a? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | yes | no | ### options ``` options() -> INT ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### patindex ``` patindex(STRING^, STRING^) -> ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### pi ``` pi() -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### power ``` power( a^, ^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### quotename ``` quotename(STRING^, STRING^{0..1}) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### radians ``` radians( a^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### rand ``` rand(^{0..1}) -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### remserver ``` remserver() -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### replace ``` replace(STRING^, STRING^, STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### replicate ``` replicate(STRING^, ^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### reverse ``` reverse(STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### right ``` right(STRING^, ^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### round ``` round( a^, ^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### rtrim ``` rtrim(STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### scope\_identity ``` scope_identity() -> ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### servername ``` servername() -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### servicename ``` servicename() -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### sign ``` sign( a^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### sin ``` sin(^) -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### smalldatetimefromparts ``` smalldatetimefromparts(^, ^, ^, ^, ^) -> DATETIME ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### soundex ``` soundex(STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### space ``` space(^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### spid ``` spid() -> INT8 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### sqrt ``` sqrt( a^) -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### square ``` square( a^) -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### stdev ``` stdev() -> FLOAT64? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### stdevp ``` stdevp() -> FLOAT64? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### str ``` str(^, {0..2}) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### string\_escape ``` string_escape(STRING^, STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### stuff ``` stuff( a^, ^, ^, STRING) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### substring ``` substring( a^, ^, ^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### sum ``` sum( a) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### sysdatetime ``` sysdatetime() -> DATETIME ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### sysdatetimeoffset ``` sysdatetimeoffset() -> DATETIMEOFFSET ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### sysutcdatetime ``` sysutcdatetime() -> DATETIME ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### tan ``` tan(^) -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### textsize ``` textsize() -> INT ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### translate ``` translate(STRING^, STRING^, STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### trim ``` trim(STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### unicode ``` unicode(STRING^) -> INT ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### unsafe\_coerce ``` unsafe_coerce(^) -> ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | yes | no | ### upper ``` upper(STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### var ``` var() -> FLOAT64? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### varp ``` varp() -> FLOAT64? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### version ``` version() -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### year ``` year(DATETIME^) -> ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | *** [← SQLite](/rezoom-sql/language/functions/sqlitefunctions.md) | [Postgres →](/rezoom-sql/language/functions/postgresfunctions.md) --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://humbobst.gitbook.io/rezoom-sql/language/functions/tsqlfunctions.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.