You might have knowledge about this but do you know it deeply enough? Well I will try to give some heads up.
As you know SQL was invented by E.F. Codd while he was working at the IBM research labs in San Jose in 1971.
- The American National Standards Institute (ANSI) published a standard for the SQL language in 1989; they set a universal standard to which database vendors could adhere. Later, in 1992, ANSI released an update to the SQL standard, known as SQL-92.
- The standards helped formalize many of the behaviors and syntax structures of SQL.
- The ANSI standard covered lots of important details concerning the querying and manipulation of data.
- The syntax was formalized for many commands; some of these are SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
Since the standards didn’t address every facet of programming for a relational database, so to meet the needs of their own user communities, database vendors began to extend the SQL language with capabilities that enhanced the basic functionality of SQL.
The Transact-SQL language was introduced by Sybase to answer user requirements for programming extensions to SQL-extensions enabling conditional processing, error handling, declared variables, row processing, and numerous other functions.
Characteristics of T-SQL:
- T-SQL is the proprietary form of SQL used by Microsoft SQL Server.
- It also includes special functions like cast, convert, date (), etc. that are not part of the ANSI standard.
- T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, date processing, mathematics, etc. and changes to the DELETE and UPDATE statements.
- T-SQL is the native language of SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application.
Hope you enjoyed reading this. Do comment so that I can improve in my next post.