ANSI SQL-92 Compatibility Print E-mail
Tuesday, 18 January 2011 08:43

ANSI SQL-92 Compatibility

How can you decide if the code that is there is really appropriate?

SQL Server, to test if the code is compatible to MS subset of ANSI SQL-92, there is a SET option

SET FIPS_FLAGGER

FIPS (Federal Information Processing Standard) 127-2, the standard for computer systems purchased by the United States government.

FIPS 127-2 is based on ANSI SQL-92.

 

Full  option : SET FIPS_FLAGGER 'FULL'

 

 

Add comment


Security code
Refresh