T-SQL
E941482
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.
All labels observed (9)
How this entity was disambiguated
This entity first appeared as the object of triple T11655686 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
NED1
Entity disambiguation (via context triple)
gpt-5-mini-2025-08-07
Target entity: T-SQL Context triple: [DQS_MAIN, language, T-SQL]
-
A.
SQL Server
SQL Server is Microsoft's enterprise-grade relational database management system used for storing, managing, and analyzing data in a wide range of applications.
-
B.
SQL
SQL (Structured Query Language) is a standardized programming language used to manage, query, and manipulate data in relational database management systems.
-
C.
SQL Server programmability feature
SQL Mail is a legacy Microsoft SQL Server feature that enables the database engine to send and receive email messages directly from Transact-SQL code using a MAPI-based mail client.
-
D.
SQL Server Management Objects (SMO)
SQL Server Management Objects (SMO) is a .NET-based object model that provides programmatic access for configuring, managing, and automating Microsoft SQL Server instances and their components.
-
E.
SQL Server Management Studio
SQL Server Management Studio is a graphical administration and development environment used to configure, manage, and query Microsoft SQL Server databases.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
NED2
Entity disambiguation (via description)
gpt-5-mini-2025-08-07
Target entity: T-SQL Target entity description: 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.
-
A.
SQL Server
SQL Server is Microsoft's enterprise-grade relational database management system used for storing, managing, and analyzing data in a wide range of applications.
-
B.
SQL
SQL (Structured Query Language) is a standardized programming language used to manage, query, and manipulate data in relational database management systems.
-
C.
SQL Server programmability feature
SQL Mail is a legacy Microsoft SQL Server feature that enables the database engine to send and receive email messages directly from Transact-SQL code using a MAPI-based mail client.
-
D.
SQL Server Management Objects (SMO)
SQL Server Management Objects (SMO) is a .NET-based object model that provides programmatic access for configuring, managing, and automating Microsoft SQL Server instances and their components.
-
E.
SQL Server Management Studio
SQL Server Management Studio is a graphical administration and development environment used to configure, manage, and query Microsoft SQL Server databases.
- F. None of above. chosen
Statements (110)
| Predicate | Object |
|---|---|
| instanceOf |
SQL extension
ⓘ
programming language ⓘ query language ⓘ |
| basedOn | SQL ⓘ |
| developer | Microsoft ⓘ |
| fullName |
Transact-SQL
ⓘ
linked to:
T-SQL
|
| 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
ⓘ
Azure SQL Managed Instance ⓘ Azure Synapse Analytics SQL pools ⓘ
linked to:
Azure Synapse Analytics
Microsoft SQL Server ⓘ
linked to:
SQL Server
|
| 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 ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: T-SQL Description of subject: 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.
Referenced by (22)
Full triples — surface form annotated when it differs from this entity's canonical label.
linked to: T-SQL
linked to: T-SQL
subject linked to:
Multiple Active Result Sets (MARS)
linked to: T-SQL
linked to: T-SQL
linked to: T-SQL
linked to: T-SQL
linked to: T-SQL
linked to: T-SQL
linked to: T-SQL
subject linked to:
SQL Server programmability feature
linked to: T-SQL
subject linked to:
DMVs
linked to: T-SQL
subject linked to:
DQS_STAGING_DATA database
linked to: T-SQL
linked to: T-SQL
linked to: T-SQL