CODIGO
log in

Transact-SQL

AKA T-SQL, TSQL

Summary

Transact-SQL (T-SQL) is Microsoft's extension of SQL used in SQL Server and Azure SQL Database. It adds procedural programming capabilities to standard SQL with features for transaction control, error handling, and local variables.

Paradigms

declarative, procedural, query

Domains

database management, data integration

Typing

static system, non-structural typing, strong typing, partial inference, compile-time checking, moderate type coercion, optional type annotations

Compilation

interpreted, query-optimized

Influenced By

SQL, Sybase SQL

Ratings

Startup time
▊▊
▊▊
▊▊
▊▊
▊▊
Memory usage
▊▊
▊▊
▊▊
▊▊
▊▊
Computation speed
▊▊
▊▊
▊▊
▊▊
▊▊
Compilation speed
▊▊
▊▊
▊▊
▊▊
▊▊
Maturity
▊▊
▊▊
▊▊
▊▊
▊▊
Community size
▊▊
▊▊
▊▊
▊▊
▊▊
Learning resources
▊▊
▊▊
▊▊
▊▊
▊▊
Job market demand
▊▊
▊▊
▊▊
▊▊
▊▊
Learning curve
▊▊
▊▊
▊▊
▊▊
▊▊
Cognitive load
▊▊
▊▊
▊▊
▊▊
▊▊
Syntax complexity
▊▊
▊▊
▊▊
▊▊
▊▊
Semantic complexity
▊▊
▊▊
▊▊
▊▊
▊▊
Memory safety
▊▊
▊▊
▊▊
▊▊
▊▊
Std lib maturity
▊▊
▊▊
▊▊
▊▊
▊▊
Std lib size
▊▊
▊▊
▊▊
▊▊
▊▊
Backwards compatibility
▊▊
▊▊
▊▊
▊▊
▊▊
Documentation quality
▊▊
▊▊
▊▊
▊▊
▊▊

File extensions

sql, tsql

External Links

Status active
Type query
Created 1987
Designed by Microsoft
Developed by Microsoft
PyPL Index N/A
TIOBE Index #51-100
GitHub rank N/A

Code Example

Loading...