set statement

Use the SET statement to alter existing fields in the logical tree or to create them in circumstances where they do not already exist.

The SET statement overrides all previous settings and can be used to turn options on and off dynamically as the application runs.

This setting also behaves like an explicit SET statement, except that it occurs at login time.

In addition, the SET statement is allowed by Adaptive Server Anywhere for the PREFETCH option, for compatibility, but has no effect.

The data type specified must be the same as the data type of the property where this Set statement is declared.

In the expression used in the following SET statement, the parentheses cause the addition to be performed first.

Neither of these SET statement options check for or require the SHOWPLAN permission.

The Transact-SQL SET statement options for displaying execution plan information produce output in XML and text.

The first nine parameters in the SET statement correspond to the first nine parameters in the parameters collection.

The Set procedure defaults to the access level of its containing property unless you use accessmodifier in the Set statement.

When you use the Transact-SQL SET statement options, you can produce estimated and actual execution plans in XML or text.

Adaptive Server Anywhere does support some Adaptive Server Enterprise options using the SET statement.

The variable contains the NULL value until it is assigned a different value by the SET statement.

Contains information about using the Transact-SQL SET statement options to display execution plans in XML format or text.

To change the length of returned text for the session, use the SET statement.

Any SET statement can be specified inside a trigger.

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

The following Transact-SQL SET statement options prevent cached query plans from being reused.

This is indicated in ESQL SET statement syntax using a colon character to separate the two sections of the Qualified Name.

Any SET statement can be specified inside a stored procedure, except SET SHOWPLAN_TEXT and SET SHOWPLAN_ALL.

This can be set by using either the user options option in sp_configure or the SET statement.

If execution fails before the SET statement is executed, the option is not set.

To assign a value to a variable, use the SET statement.

If execution fails after the SET statement is executed, the option is set.

A named set defined by using the CREATE SET statement is available to all MDX queries in that session.

Both SET statement options provide output in text.

For J2EE applications, you can set statement caching on the application server.

To assign a variable a value by using the SET statement, include the variable name and the value to assign to the variable.

Remove the invalid keyword from the Get or Set statement.

Returns the current value of the TEXTSIZE option of the SET statement.

FETCH(13) represents the first SET statement in the function, selecting from the ITEM table.

UPDATE(15) obviously is the UPDATE of the STOCK table incuding the SET statement driving it.

To change settings that affect only the current user session, use the SET statement.

The CREATE SET statement makes sense, for example, in a client application that consistently reuses a set in a variety of queries.

Then, the variable is assigned a value by using the SET statement.

A named set that is created by using the CREATE SET statement will not be removed until after the MDX session closes.

After this SET statement is executed, SQL Server returns the execution plan information for each query in text.

The Get Statement and Set Statement (Visual Basic) allow only an access modifier (Public, Protected, Friend, Protected Friend, Private).

The following somewhat artificial procedure returns a value in an OUT parameter assigned using a SET statement

Requires the same permissions needed to use the STATISTICS XML SET statement option

When you use this technique, a SET statement can be revised as follows

Considerations for Using the Showplan SET Statement Options

Optimizing ADO Calls Using the Set Statement

For more information about the Showplan SET statement options, see the following topics