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

levels 100 and 110
T-SQL Reference

value to a string value. This

#tsql#operators
Limitations
T-SQL Reference

No description available.

#tsql#statements
Limitations and considerations
T-SQL Reference

No description available.

#tsql#operators
Limitations and Recommendations
T-SQL Reference

Removes the specified availability group and all of its replicas.

#tsql#operators
Locks and ALTER TABLE
T-SQL Reference

No description available.

#tsql#statements
Logical operators
T-SQL Reference

No description available.

#tsql#operators
Logical processing order of the SELECT statement
T-SQL Reference

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

#tsql#queries
LOGINPROPERTY
T-SQL Reference

Returns information about login policy settings.

#tsql#statements
Logon triggers
T-SQL Reference

No description available.

#tsql#statements
M. Use HAVING with SUM and AVG
T-SQL Reference

No description available.

#tsql#statements
Making Added Properties Searchable
T-SQL Reference

No description available.

#tsql#statements
Marked transactions
T-SQL Reference

option causes the transaction name to be recorded in the transaction log. When

#tsql#statements
Microsoft Fabric support
T-SQL Reference

No description available.

#tsql#statements
MIN_ACTIVE_ROWVERSION
T-SQL Reference

Returns the lowest active rowversion value in the current database.

#tsql#statements
Miscellaneous statements
T-SQL Reference

DBCC CHECKCONSTRAINTS

#tsql#statements
money and smallmoney styles
T-SQL Reference

No description available.

#tsql#data-types
Money constants
T-SQL Reference

) constants are represented by a string of numbers that aren't enclosed in quotation

#tsql#data-types
MongoDB API for Cosmos DB
T-SQL Reference

Attribute (Short Name)

#tsql#statements
Multipart names
T-SQL Reference

No description available.

#tsql#statements
N. Use the INDEX optimizer hint
T-SQL Reference

No description available.

#tsql#statements
nchar and nvarchar
T-SQL Reference

T-SQL reference covering national character varying.

#tsql#data-types
Next step
T-SQL Reference

DROP SYNONYM (Transact-SQL)

#tsql#statements
Nonclustered indexes on separate filegroups
T-SQL Reference

of every table and indexed view in the filegroup.

#tsql#queries
Not equal to - exclamation
T-SQL Reference

No description available.

#tsql#operators
Nullability rules within a table definition
T-SQL Reference

A column-level CHECK constraint can reference only the constrained column, and a table-

#tsql#data-types
O. Use the UNION query hint
T-SQL Reference

No description available.

#tsql#statements
Object identification and name resolution
T-SQL Reference

No description available.

#tsql#operators
ODBC Reserved Keywords
T-SQL Reference

No description available.

#tsql#statements
Online index operations
T-SQL Reference

No description available.

#tsql#queries
Online index rebuild
T-SQL Reference

Dropping a clustered index requires temporary disk space that's equal to the size of the existing

#tsql#queries
ONLINE option
T-SQL Reference

No description available.

#tsql#queries
operations
T-SQL Reference

No description available.

#tsql#statements
Operator precedence
T-SQL Reference

No description available.

#tsql#operators
Operators
T-SQL Reference

No description available.

#tsql#operators
Oracle
T-SQL Reference

SQL) CONNECTION_OPTIONS

#tsql#operators
ORDER BY
T-SQL Reference

No description available.

#tsql#queries
Output
T-SQL Reference

No description available.

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

2016 (13.x) and later versions

#tsql#statements
Overview: SQL Server 2025
T-SQL Reference

2016 (13.x) and later versions

#tsql#statements
P. Use a UNION
T-SQL Reference

No description available.

#tsql#statements
Parallelism
T-SQL Reference

The whole operation is atomic.

#tsql#statements
Partitioned indexes
T-SQL Reference

sorting and a temporary copy of the original table or existing clustered index data.

#tsql#statements
Partitioned views
T-SQL Reference

A computation.

#tsql#statements
Pattern match using LIKE
T-SQL Reference

Here's the result set.

#tsql#predicates
Pattern match with the ESCAPE clause
T-SQL Reference

No description available.

#tsql#queries
Perform logical consistency checks on indexes
T-SQL Reference

exceeds the value configured with Resource Governor, the Database Engine uses the Resource

#tsql#queries
Performance considerations
T-SQL Reference

Beginning with SQL Server 2017 (14.x),

#tsql#statements
Permissions
T-SQL Reference

No description available.

#tsql#statements
Physical storage and full-text metadata
T-SQL Reference

Returns a data type name by ID.

#tsql#operators
Platform System (PDW)
T-SQL Reference

SET ROWCOUNT stops processing after the specified number of rows. In the following

#tsql#statements
Point (geometry Data Type)
T-SQL Reference

No description available.

#tsql#data-types
Point and curve access
T-SQL Reference

No description available.

#tsql#operators
POWER
T-SQL Reference

float float bit Input type Return type float real float decimal( p , s ) decimal(38, s )...

#tsql#statements
Precision, scale, and length
T-SQL Reference

numeric decimal varchar char nvarchar nchar binary varbinary image int int char varchar binary varbinary nchar nvarchar decimal...

#tsql#operators
Predicates
T-SQL Reference

No description available.

#tsql#statements
Predicates supported with a JSON index
T-SQL Reference

For a list of features supported by the editions of SQL Server on Windows, see:

#tsql#queries
PRIMARY KEY constraints
T-SQL Reference

statement that creates the temp table. For example, if a stored procedure creates a temporary

#tsql#statements
PRINT
T-SQL Reference

Returns a user-defined message to the client application.

#tsql#statements
Progress reporting for DBCC commands
T-SQL Reference

Sometimes an internal database snapshot isn't required or can't be created. When this occurs,

#tsql#statements
Pseudocode and semantics
T-SQL Reference

CTE query definitions are considered anchor members unless they reference the CTE

#tsql#operators
Q. Use SELECT INTO with UNION
T-SQL Reference

No description available.

#tsql#statements
Queue Columns
T-SQL Reference

When the WAITFOR clause is specified, the statement waits for the specified time out, or until a

#tsql#statements
Queues
T-SQL Reference

for parallelism depending on the subtree cost.

#tsql#statements
RADIANS
T-SQL Reference

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

#tsql#statements
Regular expressions functions (Transact-
T-SQL Reference

2025 (17.x)

#tsql#statements
Related context
T-SQL Reference

@@TRANCOUNT (Transact-SQL)

#tsql#statements
Related tasks
T-SQL Reference

The following example creates a server audit called

#tsql#statements
Relational operators
T-SQL Reference

No description available.

#tsql#statements
Remarks
T-SQL Reference

No description available.

#tsql#statements
Remarks for DDL triggers
T-SQL Reference

No description available.

#tsql#statements
Remarks for DML triggers
T-SQL Reference

For a CLR trigger, specifies the method of an assembly to bind with the trigger. The method

#tsql#statements
Removing a FILESTREAM Container
T-SQL Reference

statement that modifies a table with any index in an offline filegroup

#tsql#statements
Reorganize indexes
T-SQL Reference

On multiprocessor computers, just like other queries do,

#tsql#statements
ReorientObject (geography Data Type)
T-SQL Reference

T-SQL reference covering GeometryCollection.

#tsql#data-types
REPAIR_ALLOW_DATA_LOSS in replicated databases
T-SQL Reference

No description available.

#tsql#predicates
REPLACE option impact
T-SQL Reference

No description available.

#tsql#queries
replace value of (XML DML)
T-SQL Reference

Note the following from the previous query:

#tsql#statements
Reporting errors
T-SQL Reference

No description available.

#tsql#statements
Reserved keywords
T-SQL Reference

No description available.

#tsql#statements
Resolve errors in database emergency mode
T-SQL Reference

detects a corruption error.

#tsql#predicates
Restrictions on tables with schema-bound views
T-SQL Reference

are runtime constants. In contrast, the functions

#tsql#queries
Result Sets
T-SQL Reference

No description available.

#tsql#statements
Result value
T-SQL Reference

No description available.

#tsql#statements
Retrieve error information
T-SQL Reference

If the stored procedure contains a

#tsql#statements
Retry count
T-SQL Reference

specifies the directory on the local SQL Server instance where the ONNX

#tsql#statements
Return result set
T-SQL Reference

The vector used for search.

#tsql#statements
Returns
T-SQL Reference

Returns the number of passwords tracked for the login, using the password-

#tsql#statements
Revert a database to a database snapshot
T-SQL Reference

Restoring over a database using the full or bulk-logged recovery model where a tail-log

#tsql#hints
Rounding of datetime fractional second precision
T-SQL Reference

= timestamp (time + date)

#tsql#data-types
Row and page locks options
T-SQL Reference

No description available.

#tsql#operators
rowversion
T-SQL Reference

rowversion rowversion datetime2 rowversion rowversion rowversion rowversion rowversion rowversion rowversion timestamp rowversion rowversion timestamp timestamp timestamp

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

Configuration functions are scalar functions that return information about current

#tsql#statements
Securable-specific Syntax
T-SQL Reference

The full syntax of the REVOKE statement is complex. The syntax diagram above was simplified

#tsql#statements
Security considerations
T-SQL Reference

principal must exist even when the user is accessing the database or instance of SQL Server

#tsql#statements
Security Functions
T-SQL Reference

No description available.

#tsql#statements
See other language references
T-SQL Reference

No description available.

#tsql#statements
Service Broker Contracts
T-SQL Reference

Specifies a principal from which the principal executing this query derives its right to revoke

#tsql#statements
Service Broker Remote Service Bindings
T-SQL Reference

A Service Broker message type is a database-level securable that is contained by the database

#tsql#statements
Service Broker Routes
T-SQL Reference

No description available.

#tsql#statements
Session settings
T-SQL Reference

Data Manipulation Language (DML) affect the information stored in the database.

#tsql#statements