set option

The SET option chosen remains in effect during the execution of the stored procedure and then reverts to its former setting.

The SET option selected remains in effect during the execution of the trigger and then reverts to its former setting.

When a batch executes under that connection, the default SET option values are copied to the request's environment.

The SET option settings must be the same as those required for indexed views and computed column indexes.

The PARAMETERIZATION query hint is used to override the current setting of the PARAMETERIZATION database SET option inside a plan guide.

Errors can be treated in different ways by setting the ON_ERROR and CONVERSION_ERROR options (see SET OPTION).

Unless explicitly reset, SET option values from all higher level code apply within a stored procedure or trigger.

Adding the TEMPORARY keyword to the SET OPTION statement changes the duration that the change takes effect.

When you use the Import Script or Import Database Schema commands, SET option values are not imported for individual database objects.

However, you can specify that all queries in a database be parameterized by setting the PARAMETERIZATION database SET option to FORCED.

You can change the isolation level of a connection during a transaction using the SET OPTION statement to alter the ISOLATION_LEVEL option.

Provides access to get and set option values for a Windows Forms designer.

The XACT_ABORT SET option should be set to ON for INSERT, UPDATE, or DELETE statements to work.

By default, the option value applies to the currently logged on user ID that issued the SET OPTION statement.

Specify the desired properties within a SET OPTION statement.

Provides access to get and set option values for a designer.

In Interactive SQL, you can specify an option in a SET OPTION statement.

If you set Option Explicit to Off, you can implicitly declare a variable by simply using it in your code.

You can also set Option Explicit in the Visual Studio integrated development environment (IDE) or on a command line.

Empty SET statement (with no SET option assignments) is allowed.

The DATE_ORDER database option can have the value MDY, YMD, or DMY (see SET OPTION statement).

By default, the option value is permanent: it will not change until it is explicitly changed using the SET OPTION statement.

Static embedded SQL SET OPTION statements are not replicated.

A MARS-enabled connection maintains a list of default SET option values.

New requests that execute under the same session after this change will use these new SET option settings.

The File set option is used when a set of file-paths is given to the XML stage.

The READPAST locking hint provides an alternative to this SET option.

Database options in Adaptive Server Anywhere are set using the SET OPTION statement.

SET option settings that affect a compiled plan.

The optimistic concurrency based on result set option is recommended.

Module was created with ANSI NULLS set option set to ON.

A SET option overrides a database option.

The SET OPTION statement is used to change options that affect the behavior of the database server.

Button before using this SET option.

A hint overrides a SET option.

Users can use the SET OPTION statement to change the values for their own user ID.

DBCC USEROPTIONS returns a column for the name of the SET option and a column for the value of the option (values and entries may vary)

To set Option Explicit in the integrated development environment (IDE)

For more information about required SET option settings with indexed views and indexes on computed columns, see

Another technique to check for errors and exit is to use the set option

To set Option Explicit on the command line

To specify a pure binary comparison, set Option Compare

To specify a text comparison, set Option Compare

SET Option Settings for OLE DB and ODBC Connections