T-SQL

E941482

SQL extension programming language query language

T-SQL (Transact-SQL) is Microsoft's proprietary extension of the SQL language used primarily for managing and querying data in SQL Server and Azure SQL databases.

Try in SPARQL Jump to: Surface forms Statements Referenced by

All labels observed (3)

Label	Occurrences
T-SQL canonical	4
Transact-SQL	3
Microsoft SQL Server SQL dialect	1

Statements (110)

Predicate	Object
instanceOf	SQL extension ⓘ programming language ⓘ query language ⓘ
basedOn	SQL NERFINISHED ⓘ
developer	Microsoft ⓘ
fullName	Transact-SQL NERFINISHED ⓘ
hasDataType	BIGINT ⓘ BINARY ⓘ BIT ⓘ CHAR ⓘ DATE ⓘ DATETIME ⓘ DATETIME2 ⓘ DECIMAL ⓘ FLOAT ⓘ INT ⓘ JSON (via NVARCHAR) ⓘ NTEXT ⓘ NUMERIC ⓘ NVARCHAR ⓘ REAL ⓘ SMALLDATETIME ⓘ TEXT ⓘ TIME ⓘ UNIQUEIDENTIFIER ⓘ VARBINARY ⓘ VARCHAR ⓘ XML ⓘ
hasSyntaxElement	ALTER TABLE statement ⓘ BEGIN...END block ⓘ CREATE FUNCTION statement ⓘ CREATE PROCEDURE statement ⓘ CREATE TABLE statement ⓘ CREATE TRIGGER statement ⓘ DECLARE statement ⓘ DELETE statement ⓘ DROP TABLE statement ⓘ EXCEPT operator ⓘ EXECUTE statement ⓘ GROUP BY clause ⓘ HAVING clause ⓘ IF...ELSE statement ⓘ INSERT statement ⓘ INTERSECT operator ⓘ JOIN operators ⓘ NTILE function ⓘ ORDER BY clause ⓘ OUTPUT clause ⓘ OUTPUT parameters ⓘ OVER clause ⓘ PRINT statement ⓘ RANK function ⓘ ROW_NUMBER function ⓘ SELECT statement ⓘ SET statement ⓘ TOP clause ⓘ TRY_CONVERT function ⓘ UNION operator ⓘ UPDATE statement ⓘ WHILE loop ⓘ WITH common table expression ⓘ
primaryPlatform	Azure SQL Database NERFINISHED ⓘ Azure SQL Managed Instance NERFINISHED ⓘ Azure Synapse Analytics SQL pools NERFINISHED ⓘ Microsoft SQL Server NERFINISHED ⓘ
supportsFeature	JSON functions ⓘ MERGE statement ⓘ RAISERROR statement ⓘ SET-based operations ⓘ THROW statement ⓘ TRY...CATCH error handling ⓘ XML data type ⓘ change data capture ⓘ change tracking ⓘ common table expressions ⓘ control-of-flow statements ⓘ cursors ⓘ database mail procedures ⓘ dynamic SQL ⓘ dynamic management views ⓘ error handling ⓘ full-text search predicates ⓘ isolation level control ⓘ linked server queries ⓘ partitioned tables ⓘ plan guides ⓘ query hints ⓘ row-level locking hints ⓘ row-level security policies ⓘ schemas ⓘ security roles and permissions ⓘ service broker objects ⓘ stored procedures ⓘ system catalog views ⓘ table variables ⓘ table-valued parameters ⓘ temporal tables ⓘ temporary tables ⓘ transactions ⓘ triggers ⓘ user-defined data types ⓘ user-defined functions ⓘ variables ⓘ views ⓘ window functions ⓘ
usedFor	data control ⓘ data definition ⓘ data manipulation ⓘ procedural programming ⓘ transaction control ⓘ

Referenced by (8)

Full triples — surface form annotated when it differs from this entity's canonical label.

DQS_MAIN → language → T-SQL ⓘ

Query Editor → supports → T-SQL ⓘ

this entity surface form: Transact-SQL

Template Explorer → supportsLanguage → T-SQL ⓘ

this entity surface form: Transact-SQL

Multiple Active Result Sets (MARS) → supportsLanguage → T-SQL ⓘ

subject surface form: Multiple Active Result Sets

Azure SQL family → supportsLanguage → T-SQL ⓘ

this entity surface form: Transact-SQL

Aqua Data Studio → supportsLanguage → T-SQL ⓘ

DataGrip → supportsLanguage → T-SQL ⓘ

this entity surface form: Microsoft SQL Server SQL dialect