SQL-92 documentation 1

[seaport]

I am using SQL Server 2005. How do I know that my codes are SQL-92 compliant? When can I find its documentation on the web?

Thanks in advance.

Seaport

 

[LNBruno]

got google?

< M!ke >

 

[Lamprey13]

You can try googling for the 92 standard or compliance, but in SQL you can use SET FIPS_FLAGGER to check your code.

Per BOL:

SET FIPS_FLAGGER 'level'
 
Arguments
'level'
Is the level of compliance against the FIPS 127-2 standard for which all database operations are checked. If a database operation conflicts with the level of SQL-92 standards chosen, Microsoft SQL Server 2005 generates a warning.

level must be one of the following values. 

Value  Description  
ENTRY
 Standards checking for SQL-92 entry-level compliance.
 
FULL
 Standards checking for SQL-92 full compliance.
 
INTERMEDIATE
 Standards checking for SQL-92 intermediate-level compliance.
 
OFF
 No standards checking.

 

[seaport]

Thanks Lamprey13.

That is exactly what I need.

To my surprise, isnull function is ansi-92 compliant. I always thought it was of microsoft creation.

Seaport

 

[swampBoogie]

Isnull is not standard SQL. Coalesce is.

 

[seaport]

swampBoogie,

I agree. I only wanted to point out that SQL Server 2005 does not raise a warning after I "SET FIPS_FLAGGER 'FULL'".

Seaport