T-SQL Definitions
-
A
ACID (atomicity, consistency, isolation, and durability)
ACID (atomicity, consistency, isolation, and durability) is an acronym and mnemonic device for learning and remembering the four primary attributes ensured to any transaction by a transaction manager (which is also called a transaction monitor).
-
Azure Data Studio (formerly SQL Operations Studio)
Azure Data Studio is a Microsoft tool, originally named SQL Operations Studio, for managing SQL Server databases and cloud-based Azure SQL Database and Azure SQL Data Warehouse systems.
-
C
Collaboration Data Objects (CDO)
Collaboration Data Objects (CDO) is Microsoft's technology for building messaging or collaboration applications or adding these capabilities to existing applications.
-
commit
A commit is the final step in the successful completion of a previously started database change as part of handling a transaction in a computing system.
-
Java container
In Sun Microsystems' JavaBeans component architecture and in Microsoft's Component Object Model (COM), a container is an application program or subsystem in which the program building block known as a component is run.
-
D
DAO (Data Access Objects)
DAO (Data Access Objects) is an application program interface (API) available with Microsoft's Visual Basic that lets a programmer request access to a Microsoft Access database.
-
F
fetch
In computer technology, fetch has several meanings related to getting, reading, or moving data objects.
-
I
In-Memory OLTP
In-Memory OLTP is a Microsoft in-memory technology built into SQL Server and optimized for transaction processing applications.
-
O
OLE DB (OLEDB or Object Linking and Embedding Database)
OLE DB is Microsoft's strategic low-level application program interface (API) for access to different data sources.
-
Q
query
A query is a question, often expressed in a formal way. A database query can be either a select query or an action query.
-
S
Microsoft SQL Server
Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments
-
SQL (Structured Query Language)
SQL (Structured Query Language) is a standardized programming language that's used to manage relational databases and perform various operations on the data in them.
-
T
T-SQL (Transact-SQL)
T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL), including transaction control, exception and error handling, row processing and declared variables.
-
U
U-SQL
U-SQL is a Microsoft query language that combines a declarative SQL-like syntax with C# programming, enabling it to be used to process both structured and unstructured data in big data environments.