Transact SQL: programming language, close to scripting language
Transact SQL is based on SQL-92 standard (fully compliant)
It is the standard for SQL language setting up by American National Standard Institute (ANSI) and International Standards Organization (ISO)

Transact SQL is an extension to standard SQL utilized by Microsoft and Sybase.

Row processing or declarative evaluates every single piece of data.
Set processing or procedural works on sets or ranges.

T is for Transaction

Databases start in the late 1960's

Mainframe has two types: hierarchical and non-relational databases

Dr. E.F. Codd gave birth to the relational database in 1970.

12 Principles of Relational Databases by Dr. Codd in 1974. It is actually 13.

Early 1990's: Ashton Tate's dBase came out
Then Microsoft Access

IBM developed in the mid 1970's

SQL-89 or SQL -1 is the first standard

SEQUEL: Structured English Query Language changed to SQL for legal issues (Structured Query Language)

Oracle was the first company to bring a SQL based RDMS (Sequel based relational database management system) to the market.

SQL-99 or Sequel 3

Pinning: placing objects usually tables in RAM

RDBMS: Relational Management System

BCP: Bulk Copy Program

ODBC & OLE DB: Database Access API's

SARG: Searchable Argument comes after the where clause to tell the database where to look for

DBCC: family of commands for database consistency checker such as maintainance, troubleshooting, investigating, or tasks issues

GUID: Globally Unique Identifier

BLOB: Binary Large Object stores up to 2GB


| Post New Message