Transact-SQL

GPTKB entity

Properties (53)
Predicate Object
gptkbp:instanceOf Programming Language
gptkbp:developedBy gptkb:Microsoft
gptkbp:firstAppearance gptkb:SQL_Server_6.0
gptkbp:hasGoals gptkb:PL/SQL
T-SQL
gptkbp:hasVersion gptkb:SQL_Server_2000
gptkb:SQL_Server_2019
gptkb:SQL_Server_6.5
gptkb:SQL_Server_2012
gptkb:SQL_Server_2016
gptkb:SQL_Server_7.0
gptkb:SQL_Server_2017
SQL Server 2008
SQL Server 2014
SQL Server 2005
https://www.w3.org/2000/01/rdf-schema#label Transact-SQL
gptkbp:isCompatibleWith gptkb:Microsoft_Excel
gptkb:Microsoft_Power_BI
gptkb:Microsoft_Access
gptkb:SQL_Server_Reporting_Services_(SSRS)
gptkb:SQL_Server_Integration_Services_(SSIS)
Visual Studio
gptkbp:isDocumentedIn Microsoft_Documentation
gptkbp:isExemplifiedBy gptkb:SQL
gptkbp:isPartOf Microsoft_SQL_Server_Ecosystem
gptkbp:isUsedBy Software Developers
Data Analysts
Database_Administrators
Business_Intelligence_Professionals
gptkbp:isUsedIn gptkb:SQL_Server_Compact
gptkb:Microsoft_SQL_Server
Azure SQL Database
Azure SQL Managed Instance
gptkbp:provides Error Handling
Built-in Functions
Stored Procedures
Triggers
User-Defined Functions
Control-of-Flow Language
gptkbp:supports Transactions
Data Manipulation Language (DML)
Common Table Expressions (CTEs)
Dynamic SQL
JSON Data Type
Window Functions
XML Data Type
Temporary Tables
Table Variables
Data_Definition_Language_(DDL)
Procedural_Programming
Error_Handling_with_TRY...CATCH
Transaction_Control_Language_(TCL)
gptkbp:usedFor Database_Management