Certain behaviors defined by the SQL standards are incompatible with Adaptive Server applications. Transact-SQL provides set options that allow you to toggle these behaviors.
By default, compliant behavior is enabled for all Embedded SQL™ precompiler applications. Other applications needing to match SQL standard behavior can use the options in Table 1-1 for entry-level ANSI SQL compliance. See the Reference Manual: Commands.
Option |
Setting |
|---|---|
ansi_permissions |
on |
ansinull |
on |
arithabort |
off |
arithabort numeric_truncation |
on |
arithignore |
off |
chained |
on |
close on endtran |
on |
fipsflagger |
on |
quoted_identifier |
on |
string_rtruncation |
on |
transaction isolation level |
3 |
The following sections describe the differences between standard behavior and default Transact-SQL behavior.
