MS SQL Server, Sybase, and SQL Anywhere QUOTED_IDENTIFIER settings
By default, the drivers RazorSQL uses to connect to SQL Server, Sybase
and SQL Anywhere databases set the QUOTED_IDENTIFIER setting to ON.
To change the status of the QUOTED_IDENTIFIER, the following statement
would need to be executed:
SET QUOTED_IDENTIFIER OFF
The RazorSQL tools that generate SQL use the select @@OPTIONS query to
determine the status of the QUOTED_IDENTIFIER before generating SQL.
If QUOTED_IDENTIFIER is set to ON, RazorSQL wraps objects with
spaces or special characters in double-quotes. If QUOTED_IDENTIFIER
is OFF, RazorSQL uses braces to wrap objects.
If care is taken to make sure that any names used are not the names
of existing database objects or contain spaces or special characters,
there is little potential for conflicts.
