DMVs Waits Cookbook Scripts XEvents SPs Catalog Functions Errors T-SQL Arch Ops

T-SQL Reference

SQL Server Transact-SQL language reference covering statements, queries, data types, operators, functions, hints, predicates, transactions, and language elements. — Page 5 of 6.

Unicode strings
T-SQL Reference

The following are examples of character strings:

#tsql#data-types
uniqueidentifier
T-SQL Reference

A 16-byte GUID (globally unique identifier) data type.

#tsql#data-types
UNISTR
T-SQL Reference

T-SQL reference covering Support for Unicode escape sequences.

#tsql#statements
UNPIVOT example
T-SQL Reference

No description available.

#tsql#queries
Unsupported or error-prone scenarios
T-SQL Reference

No description available.

#tsql#operators
Updatable views
T-SQL Reference

When a view is created, information about the view is stored in the following catalog views:

#tsql#statements
Upgrade databases
T-SQL Reference

and a path that only visits the root is represented by a single slash.

#tsql#statements
Upgrade vector indexes to the latest version
T-SQL Reference

Newly created vector indexes automatically use the latest data structure, which provides:

#tsql#statements
Usage guidelines
T-SQL Reference

Specifies a column name in the common table expression. Duplicate names within a single CTE

#tsql#statements
Use APPLY
T-SQL Reference

No description available.

#tsql#statements
Use compatibility level for backward compatibility
T-SQL Reference

No description available.

#tsql#statements
Use EXECUTE AS CALLER stand-alone statement
T-SQL Reference

For example, assume the following conditions:

#tsql#statements
Use EXECUTE with stored procedures
T-SQL Reference

Nesting occurs when one module calls another or executes managed code by referencing a

#tsql#statements
Use hierarchyid columns in replicated tables
T-SQL Reference

If a user type with conflicting name exists during the upgrade, no special steps are taken. After

#tsql#statements
Use NOEXPAND
T-SQL Reference

Isolation level hints:

#tsql#statements
Use options with DROP INDEX
T-SQL Reference

When indexes with 128 extents or more are dropped, the Database Engine defers the actual

#tsql#statements
Use PIVOT and UNPIVOT
T-SQL Reference

can include table-valued functions, but it can't contain

#tsql#statements
Use WITH STATUSONLY
T-SQL Reference

Used to kill an unresolved distributed transaction with rollback. Only applicable to distributed

#tsql#statements
Validation statements
T-SQL Reference

No description available.

#tsql#statements
Validity tests
T-SQL Reference

Returns a geometry object representing all points within a specified distance from a

#tsql#statements
Variable scope
T-SQL Reference

To declare more than one local variable, use a comma after the first local variable definition,

#tsql#variables
Vector data type
T-SQL Reference

T-SQL reference for Vector data type syntax and usage.

#tsql#data-types
Vector functions
T-SQL Reference

2025 (17.x)

#tsql#statements
Version availability
T-SQL Reference

Syntax for Azure Synapse Analytics and Analytics Platform System (PDW):

#tsql#statements
Version compatibility
T-SQL Reference

Filter (geometry Data

#tsql#statements
views
T-SQL Reference

No description available.

#tsql#statements
Week and weekday datepart arguments
T-SQL Reference

No description available.

#tsql#operators
wildcard character
T-SQL Reference

symbol is specified, the Database Engine searches for the number

#tsql#statements
Windows collations
T-SQL Reference

No description available.

#tsql#statements
WITH GRANT OPTION
T-SQL Reference

Granting a permission removes

#tsql#statements
Working with parquet
T-SQL Reference

In Azure Synapse Analytics dedicated SQL pools, and Analytics Platform System, PolyBase

#tsql#queries
xml data type
T-SQL Reference

When you convert between

#tsql#data-types
xquery-additional-sample-xqueries-against-the-xml-data-type
T-SQL Reference

XQuery Language Reference: Additional Sample XQueries Against the xml Data Type

#xquery#additional-sample-xqueries-against-the-xml-data-type
xquery-aggregate-functions-avg
T-SQL Reference

No description available.

#xquery#aggregate-functions-avg
xquery-aggregate-functions-count
T-SQL Reference

No description available.

#xquery#aggregate-functions-count
xquery-aggregate-functions-max
T-SQL Reference

No description available.

#xquery#aggregate-functions-max
xquery-aggregate-functions-min
T-SQL Reference

No description available.

#xquery#aggregate-functions-min
xquery-aggregate-functions-sum
T-SQL Reference

No description available.

#xquery#aggregate-functions-sum
xquery-arithmetic-expressions
T-SQL Reference

XQuery Language Reference: Arithmetic Expressions

#xquery#arithmetic-expressions
xquery-atomization
T-SQL Reference

XQuery Language Reference: Atomization

#xquery#atomization
xquery-boolean-constructor-functions-false
T-SQL Reference

No description available.

#xquery#boolean-constructor-functions-false
xquery-boolean-constructor-functions-true
T-SQL Reference

No description available.

#xquery#boolean-constructor-functions-true
xquery-comments-in-xquery
T-SQL Reference

XQuery Language Reference: Comments in XQuery

#xquery#comments-in-xquery
xquery-comparison-expressions
T-SQL Reference

XQuery Language Reference: Comparison Expressions

#xquery#comparison-expressions
xquery-conditional-expressions
T-SQL Reference

XQuery Language Reference: Conditional Expressions

#xquery#conditional-expressions
xquery-constructor-functions
T-SQL Reference

XQuery Language Reference: Constructor Functions

#xquery#constructor-functions
xquery-context-functions-last
T-SQL Reference

No description available.

#xquery#context-functions-last
xquery-context-functions-position
T-SQL Reference

XQuery Language Reference: Context Functions - position

#xquery#context-functions-position
xquery-data-accessor-functions
T-SQL Reference

XQuery Language Reference: Data Accessor Functions

#xquery#data-accessor-functions
xquery-data-accessor-functions-data
T-SQL Reference

No description available.

#xquery#data-accessor-functions-data
xquery-data-accessor-functions-string
T-SQL Reference

XQuery Language Reference: Data Accessor Functions - string

#xquery#data-accessor-functions-string
xquery-effective-boolean-value
T-SQL Reference

XQuery Language Reference: Effective Boolean Value

#xquery#effective-boolean-value
xquery-error-handling
T-SQL Reference

XQuery Language Reference: Error Handling

#xquery#error-handling
xquery-expression-context-query-evaluation
T-SQL Reference

XQuery Language Reference: Expression Context & Query Evaluation

#xquery#expression-context-query-evaluation
xquery-flwor-statement-iteration
T-SQL Reference

XQuery Language Reference: FLWOR Statement & Iteration

#xquery#flwor-statement-iteration
xquery-functions-on-boolean-values-not-function
T-SQL Reference

XQuery Language Reference: Functions on Boolean Values - not Function

#xquery#functions-on-boolean-values-not-function
xquery-functions-on-nodes-local-name
T-SQL Reference

XQuery Language Reference: Functions on Nodes - local-name

#xquery#functions-on-nodes-local-name
xquery-functions-on-nodes-namespace-uri
T-SQL Reference

XQuery Language Reference: Functions on Nodes - namespace-uri

#xquery#functions-on-nodes-namespace-uri
xquery-functions-on-nodes-number
T-SQL Reference

XQuery Language Reference: Functions on Nodes - number

#xquery#functions-on-nodes-number
xquery-functions-on-sequences-distinct-values
T-SQL Reference

XQuery Language Reference: Functions on Sequences - distinct-values

#xquery#functions-on-sequences-distinct-values
xquery-functions-on-sequences-empty
T-SQL Reference

No description available.

#xquery#functions-on-sequences-empty
xquery-functions-on-sequences-id
T-SQL Reference

No description available.

#xquery#functions-on-sequences-id
xquery-functions-on-string-values-concat
T-SQL Reference

XQuery Language Reference: Functions on String Values - concat

#xquery#functions-on-string-values-concat
xquery-functions-on-string-values-contains
T-SQL Reference

XQuery Language Reference: Functions on String Values - contains

#xquery#functions-on-string-values-contains
xquery-functions-on-string-values-lower-case
T-SQL Reference

XQuery Language Reference: Functions on String Values - lower-case

#xquery#functions-on-string-values-lower-case
xquery-functions-on-string-values-string-length
T-SQL Reference

XQuery Language Reference: Functions on String Values - string-length

#xquery#functions-on-string-values-string-length
xquery-functions-on-string-values-substring
T-SQL Reference

XQuery Language Reference: Functions on String Values - substring

#xquery#functions-on-string-values-substring
xquery-functions-on-string-values-upper-case
T-SQL Reference

XQuery Language Reference: Functions on String Values - upper-case

#xquery#functions-on-string-values-upper-case
xquery-functions-related-to-qnames-expanded-qname
T-SQL Reference

XQuery Language Reference: Functions Related to QNames - expanded-QName

#xquery#functions-related-to-qnames-expanded-qname
xquery-functions-related-to-qnames-local-name-from-qname
T-SQL Reference

XQuery Language Reference: Functions Related to QNames - local-name-from-QName

#xquery#functions-related-to-qnames-local-name-from-qname
xquery-functions-related-to-qnames-namespace-uri-from-qname
T-SQL Reference

XQuery Language Reference: Functions Related to QNames - namespace-uri-from-QName

#xquery#functions-related-to-qnames-namespace-uri-from-qname
xquery-general-xquery-use-cases
T-SQL Reference

XQuery Language Reference: General XQuery Use Cases

#xquery#general-xquery-use-cases
xquery-handling-namespaces-in-xquery
T-SQL Reference

XQuery Language Reference: Handling Namespaces in XQuery

#xquery#handling-namespaces-in-xquery
xquery-logical-expressions
T-SQL Reference

XQuery Language Reference: Logical Expressions

#xquery#logical-expressions
xquery-modules-prologs
T-SQL Reference

XQuery Language Reference: Modules & Prologs

#xquery#modules-prologs
xquery-modules-prologs-xquery-prolog
T-SQL Reference

XQuery Language Reference: Modules & Prologs - XQuery Prolog

#xquery#modules-prologs-xquery-prolog
xquery-numeric-values-functions-ceiling
T-SQL Reference

XQuery Language Reference: Numeric Values Functions - ceiling

#xquery#numeric-values-functions-ceiling
xquery-numeric-values-functions-floor
T-SQL Reference

No description available.

#xquery#numeric-values-functions-floor
xquery-numeric-values-functions-round
T-SQL Reference

No description available.

#xquery#numeric-values-functions-round
xquery-ordered-unordered-expressions
T-SQL Reference

XQuery Language Reference: Ordered & Unordered Expressions

#xquery#ordered-unordered-expressions
xquery-path-expressions
T-SQL Reference

XQuery Language Reference: Path Expressions

#xquery#path-expressions
xquery-path-expressions-specifying-axis
T-SQL Reference

XQuery Language Reference: Path Expressions - Specifying Axis

#xquery#path-expressions-specifying-axis
xquery-path-expressions-specifying-node-test
T-SQL Reference

XQuery Language Reference: Path Expressions - Specifying Node Test

#xquery#path-expressions-specifying-node-test
xquery-path-expressions-specifying-predicates
T-SQL Reference

XQuery Language Reference: Path Expressions - Specifying Predicates

#xquery#path-expressions-specifying-predicates
xquery-path-expressions-using-abbreviated-syntax
T-SQL Reference

XQuery Language Reference: Path Expressions - Using Abbreviated Syntax

#xquery#path-expressions-using-abbreviated-syntax
xquery-primary-expressions
T-SQL Reference

XQuery Language Reference: Primary Expressions

#xquery#primary-expressions
xquery-quantified-expressions
T-SQL Reference

XQuery Language Reference: Quantified Expressions

#xquery#quantified-expressions
xquery-sequence-expressions
T-SQL Reference

XQuery Language Reference: Sequence Expressions

#xquery#sequence-expressions
xquery-sequence-qnames
T-SQL Reference

XQuery Language Reference: Sequence & QNames

#xquery#sequence-qnames
xquery-sequencetype-expressions
T-SQL Reference

XQuery Language Reference: SequenceType Expressions

#xquery#sequencetype-expressions
xquery-string-search-in-xquery
T-SQL Reference

XQuery Language Reference: String Search in XQuery

#xquery#string-search-in-xquery
xquery-type-casting-rules-in-xquery
T-SQL Reference

XQuery Language Reference: Type Casting Rules in XQuery

#xquery#type-casting-rules-in-xquery
xquery-type-system
T-SQL Reference

XQuery Language Reference: Type System

#xquery#type-system
xquery-type-system-sequence-type-matching
T-SQL Reference

XQuery Language Reference: Type System - Sequence Type Matching

#xquery#type-system-sequence-type-matching
xquery-validate-expressions
T-SQL Reference

XQuery Language Reference: Validate Expressions

#xquery#validate-expressions
xquery-xml-construction
T-SQL Reference

XQuery Language Reference: XML Construction

#xquery#xml-construction
xquery-xqueries-handling-relational-data
T-SQL Reference

XQuery Language Reference: XQueries Handling Relational Data

#xquery#xqueries-handling-relational-data
xquery-xqueries-involving-hierarchy
T-SQL Reference

XQuery Language Reference: XQueries Involving Hierarchy

#xquery#xqueries-involving-hierarchy
xquery-xqueries-involving-order
T-SQL Reference

XQuery Language Reference: XQueries Involving Order

#xquery#xqueries-involving-order
xquery-xquery
T-SQL Reference

XQuery Language Reference: xQuery

#xquery#xquery