Hi Folks,
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.
About ANSI-SQL:
- 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.
Regards
Piyush Bajaj
Like us on FaceBook | Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook
Follow me on Twitter | Follow me on FaceBook
Didn’t knew that TSQL was introduced by Sybase . Always thought that it was developed by Microsoft.
Yes, an excerpt from wiki on how it happened.
“..Sybase called the database server “Sybase SQL Server” and made a deal with Microsoft to share the source code for Microsoft to remarket on the OS/2 platform as “SQL Server”. Until version 4.9, Sybase and Microsoft SQL Server were virtually identical. Due to disagreements between the two companies over revenue sharing (or lack thereof), Sybase and Microsoft decided to split the code-lines and went their own way, although the shared heritage is very evident in the Transact-SQL (T-SQL) procedural language as well as the basic process architecture. The big difference is that Sybase has a Unix heritage, while Microsoft SQL Server was adapted and optimized only for the Microsoft Windows NT operating system (vendor lock-in). Sybase continues to offer versions for Windows, several varieties of Unix, and for Linux….”
Hi han jon and Sachin, well thanx for your response. It was a great learning.
Hi Piyush, Nice one… A brief history of the evolution of MS SQL Server since 1987 can be found here…
http://e-articles.info/e/a/title/A-Brief-History-of-Microsoft-SQL-Server/
Thanks Amit. Its good to see your response and an article from you.