SQL-92 statement settings

These are SQL-92 setting statements that enable SQL Server 2000/2005 to comply with SQL-92 rules.
When set quoted_identifier is on, the identifiers can be separated by double quotation marks, and the text must be separated by single quotation marks. When set quoted_identifier is off, the identifier cannot be enclosed in quotation marks and must comply with all rules for the transact-SQL identifier.
The SQL-92 standard requires that the value be false when a null value is equal to (=) or not equal to (<>. When set ansi_nulls is on, even if column_name contains a null value, the SELECT statement using where column_name = NULL still returns zero rows. Even if column_name contains non-null values, the SELECT statement using where column_name <> null still returns zero rows.
When set ansi_nulls is off, equal to (=) and not equal to (<>) Comparison operators do not comply with SQL-92 standards. Use the SELECT statement where column_name = NULL to return the rows containing null values in column_name. Use the where column_name <> null SELECT statement to return rows with non-null values in the column. In addition, use the SELECT statement where column_name <> xyz_value to return all rows that are neither xyz_value nor null.