Chapter 2. Elements of Transact-SQL
SQL, or Structured Query Language, is the language used to access and interact with a relational database. It was created by IBM in the 1970s and first standardized by the American National Standards Institute (ANSI) in 1989. ANSI released a new version of the standard in 1992, known as SQL-92 or SQL2.
Although all relational management systems, including SQL Server, are ANSI compliant at different levels, they provide extensions to the SQL language that extend the language's functionality. However, be aware that the code becomes less portable by using these extensions. Therefore, it's up to the programmer to comply or not comply with the ANSI standard.
Transact-SQL is the SQL Server implementation of the ANSI ...
Get Microsoft® SQL Server™ 2000 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
