O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required