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 2 of 6.

Database User Permissions
T-SQL Reference

Database_user_mapped_to_Windows_User

#tsql#statements
Date and time data types
T-SQL Reference

Lists and describes the date and time data types available in T-SQL, including their ranges, accuracy, and storage sizes.

#tsql#data-types
Date and time functions
T-SQL Reference

The following tables list the Transact-SQL date and time functions.

#tsql#data-types
Date and time styles
T-SQL Reference

No description available.

#tsql#data-types
Date and time-related articles
T-SQL Reference

No description available.

#tsql#data-types
date Argument
T-SQL Reference

No description available.

#tsql#data-types
date description
T-SQL Reference

No description available.

#tsql#data-types
Date-time constants
T-SQL Reference

Binary constants have the prefix

#tsql#data-types
datepart boundaries
T-SQL Reference

No description available.

#tsql#data-types
datetime
T-SQL Reference

No description available.

#tsql#data-types
datetime2 description
T-SQL Reference

No description available.

#tsql#data-types
datetimeoffset description
T-SQL Reference

No description available.

#tsql#data-types
DBCC internal database snapshot usage
T-SQL Reference

No description available.

#tsql#statements
DBCC SHOW_STATISTICS
T-SQL Reference

No description available.

#tsql#statements
Declare a Transact-SQL variable
T-SQL Reference

No description available.

#tsql#language-elements
definition but not in general subquery
T-SQL Reference

```sql VALUES (1, 1, 1); INSERT INTO NestedCTE_t1 VALUES (2, 2, 2); INSERT INTO NestedCTE_t1 VALUES (3, 3, 3); GO.

#tsql#queries
DEGREES
T-SQL Reference

Input type Return type float real float decimal( p , s ) decimal(38, s ) int smallint tinyint...

#tsql#statements
Deprecation notice
T-SQL Reference

In some cases, a user can use a database without having a database user account (a database

#tsql#statements
Differences between compatibility levels
T-SQL Reference

resulting in different converted values.

#tsql#predicates
DML support
T-SQL Reference

DacPac, BACPAC, or the Import/Export service, the import process creates schema objects

#tsql#statements
DML)
T-SQL Reference

No description available.

#tsql#statements
DROP_EXISTING clause
T-SQL Reference

No description available.

#tsql#statements
E. Use correlated subqueries
T-SQL Reference

A correlated subquery is a query that depends on the outer query for its values.

#tsql#statements
Enhanced collations
T-SQL Reference

The Database Engine supports character and Unicode string constants that support enhanced

#tsql#statements
Enhanced representation formats
T-SQL Reference

Describes enhanced date and time representation formats available in T-SQL for greater precision and compatibility.

#tsql#statements
Example
T-SQL Reference

ALTER permission on the table or view is required to run DROP INDEX.

#tsql#statements
Example with ONNX Runtime running locally
T-SQL Reference

No description available.

#tsql#queries
Example: Cross-domain Query Using sql:variable()
T-SQL Reference

No description available.

#tsql#variables
Examples
T-SQL Reference

To view the current setting for this setting, run the following query.

#tsql#statements
Examples for nonclustered columnstore indexes
T-SQL Reference

There are two ways to maintain the clustered columnstore index, and both methods achieved

#tsql#statements
Examples with remote endpoints
T-SQL Reference

No description available.

#tsql#queries
Examples: Analytics Platform System (PDW)
T-SQL Reference

The following example drops the certificate

#tsql#statements
Examples: Azure Synapse Analytics
T-SQL Reference

: SQL Server 2019 (15.x).

#tsql#statements
Examples: Bulk Operations
T-SQL Reference

No description available.

#tsql#statements
Examples: Columnstore indexes
T-SQL Reference

These examples apply to columnstore indexes.

#tsql#statements
Examples: Microsoft Fabric Data Warehouse
T-SQL Reference

No description available.

#tsql#statements
Examples: Rowstore indexes
T-SQL Reference

This sample removes the archive compression, and only uses columnstore compression.

#tsql#statements
Examples: SQL Server
T-SQL Reference

permissions on the specified user name. When no execution context is specified,

#tsql#statements
Examples: SQL Server , Azure SQL Database, and
T-SQL Reference

No description available.

#tsql#operators
Expected behaviors
T-SQL Reference

The following sample demonstrates the INNER JOIN with filtering on multiple tables.

#tsql#statements
Expression results
T-SQL Reference

No description available.

#tsql#statements
Extended methods on geography instances
T-SQL Reference

T-SQL reference covering Extended methods.

#tsql#queries
F. Use GROUP BY
T-SQL Reference

This example uses two correlated subqueries to find the names of employees who sold a

#tsql#statements
Feature availability
T-SQL Reference

No description available.

#tsql#statements
File metadata functions
T-SQL Reference

No description available.

#tsql#statements
Filtered indexes
T-SQL Reference

No description available.

#tsql#statements
Find system views
T-SQL Reference

No description available.

#tsql#statements
float and real
T-SQL Reference

T-SQL reference covering double precision.

#tsql#data-types
FLOOR
T-SQL Reference

Input type Return type float real float decimal( p , s ) decimal( p , 0) int smallint...

#tsql#statements
FOR BROWSE
T-SQL Reference

Specifies that updates are allowed while viewing the data in a DB-Library browse mode cursor.

#tsql#statements
FOR JSON
T-SQL Reference

No description available.

#tsql#queries
FOR XML
T-SQL Reference

Specifies that the results of a query are to be returned as an XML document.

#tsql#queries
FOREIGN KEY constraints
T-SQL Reference

No description available.

#tsql#statements
Fractional time scale precision
T-SQL Reference

Accepts any expression, column, or user-defined variable that can resolve to any valid T-SQL

#tsql#data-types
FULLTEXT STOPLIST Permissions
T-SQL Reference

No description available.

#tsql#statements
FULLTEXTSERVICEPROPERTY
T-SQL Reference

Returns information about Full-Text Search service-level properties.

#tsql#statements
Function collation
T-SQL Reference

Perform logical operations.

#tsql#statements
Function support
T-SQL Reference

data type must be a JSON object or a JSON array.

#tsql#statements
Future Keywords
T-SQL Reference

No description available.

#tsql#statements
General Remarks
T-SQL Reference

No description available.

#tsql#statements
General trigger considerations
T-SQL Reference

The ability to return results from triggers will be removed in a future version of SQL Server.

#tsql#statements
Generic ODBC
T-SQL Reference

Make sure to configure the driver to sample all the necessary data.

#tsql#statements
Geometry simplification
T-SQL Reference

ToString (geometry Data

#tsql#data-types
GeomFromGML (geography Data Type)
T-SQL Reference

Constructs a geography instance from a GML representation.

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

2017 (14.x) and later versions

#tsql#statements
GROUPING_ID() equivalents
T-SQL Reference

No description available.

#tsql#statements
hierarchyid data type method reference
T-SQL Reference

T-SQL reference covering Extremely compact.

#tsql#data-types
Hints
T-SQL Reference

No description available.

#tsql#hints
Histogram
T-SQL Reference

(4, 4, 6), (4, 5, 6), (4, 5, 7). Using the prefix (A, B) the same column values have these distinct

#tsql#statements
How DBCC SHRINKDATABASE works
T-SQL Reference

size explicitly set by using a file size changing operation.

#tsql#statements
I. Use GROUP BY with an expression
T-SQL Reference

No description available.

#tsql#statements
Implicit and explicit conversion
T-SQL Reference

No description available.

#tsql#operators
Implicit conversions
T-SQL Reference

Translates ASCII characters to binary bytes, or binary bytes to ASCII characters. Each character

#tsql#statements
In This Section
T-SQL Reference

No description available.

#tsql#predicates
Included columns in indexes
T-SQL Reference

No description available.

#tsql#predicates
Index best practices
T-SQL Reference

No description available.

#tsql#hints
Index key size
T-SQL Reference

compatibility level is set to 90 or higher.

#tsql#hints
Index statistics
T-SQL Reference

To evaluate how changing the compression state affects the space usage by a table, an index,

#tsql#hints
Indexes and ALTER TABLE
T-SQL Reference

statement requires changing a column used in a schema-bound view,

#tsql#statements
INSERT Into node table syntax
T-SQL Reference

2017 (14.x) and later versions

#tsql#queries
Inspect vector base type metadata
T-SQL Reference

The following query confirms actual base type and dimensions of a

#tsql#predicates
instance with an inscribed Polygon instance
T-SQL Reference

No description available.

#tsql#queries
InstanceOf (geography Data Type)
T-SQL Reference

T-SQL reference covering GeometryCollection.

#tsql#predicates
InstanceOf (geometry Data Type)
T-SQL Reference

T-SQL reference covering GeometryCollection.

#tsql#predicates
int, bigint, smallint, and tinyint (Transact-
T-SQL Reference

tinyint tinyint Data type Range Range expression Storage bigint int smallint tinyint int bigint int bigint smallmoney int...

#tsql#data-types
intersect, and except
T-SQL Reference

CTE names can be reused at different nesting levels. CTE names at the same nesting level can't

#tsql#queries
iso_week datepart
T-SQL Reference

ISO 8601 includes the ISO week-date system, a numbering system for weeks.

#tsql#statements
JSON functions
T-SQL Reference

2016 (13.x) and later versions

#tsql#statements
JSON_ARRAY
T-SQL Reference

The following example returns rows in which the column

#tsql#statements
JSON_ARRAYAGG
T-SQL Reference

2025 (17.x)

#tsql#statements
JSON_OBJECTAGG
T-SQL Reference

2025 (17.x)

#tsql#statements
K. Use the HAVING clause
T-SQL Reference

The following example finds the average price of each type of product and orders the results

#tsql#statements
Key benefits of float16 support
T-SQL Reference

2025 (17.x)

#tsql#statements
level 100
T-SQL Reference

No description available.

#tsql#statements
level 120
T-SQL Reference

No description available.

#tsql#statements
level 130
T-SQL Reference

No description available.

#tsql#statements
level 140
T-SQL Reference

consecutive executions. For more information,

#tsql#statements
level 150
T-SQL Reference

No description available.

#tsql#statements
level 160
T-SQL Reference

No description available.

#tsql#statements
level 170
T-SQL Reference

compatibility level (140). Database compatibility level 130 retained the SQL Server 2016

#tsql#statements