Additional Elements

In addition to DDL, DML, DCL, and data types, Transact-SQL has some additional elements or extensions that make life easier for programmers and administrators, and also make Transact-SQL a more powerful language. Be aware that these extensions are not ANSI-SQL standard; therefore, they are not portable. If you are concerned about portability, you should avoid using any of these extensions.

SQL Server is not the only relational database management system that adds new elements to the standard language; this is done by the majority of the commercial database systems today. If you want to check that your code is compliant with the ANSI standard, use the SET FIPS_FLAGGER statement provided by SQL Server, which receives as a parameter ...

Get Microsoft® SQL Server™ 2000 Programming by Example now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.