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