Generates a TSQL stored procedure. When unchecked, OpenESQL Assistant does not generate a stored procedure query. Available
when the
Type Stored Procedure OpenESQL Assistant Option is set to
TSQL and you have selected a SQL Server data source.
Generate query as SQL CLR stored procedure
Generates a SQL CLR stored procedure. When unchecked, OpenESQL Assistant does not generate a stored procedure query. Available
when the
Type Stored Procedure OpenESQL Assistant Option is set to
SQL CLR and you have selected a SQL Server data source.
Generate query with FOR UPDATE
Generates a FOR UPDATE clause as part of a SELECT (cursor) or SELECT DISTINCT (cursor) SQL query.
Generate query with WHERE CURRENT OF
Generates a WHERE CURRENT OF clause as part of an UPDATE or DELETE SQL query.
SP Name
The name of the stored procedure you want to generate. A default name is supplied; however, you can override this by typing
in a name of your choice. Applies to stored procedure queries only. Available only when you have selected a SQL Server data
source.
Cursor Name
The name of the cursor generated for the query. A default name is supplied; however, you can override this by typing in a
name of your choice. Available when the
Generate OpenESQL Assistant Option is set to
EXEC SQL.
Datarows Name
The name of the DATAROWS instance declared in the query. A default name is supplied; however, you can override this by typing
in a name of your choice. Available when the
Mode OpenESQL Assistant Option is set to
ADO.NET and the
Generate option is set to either
EXEC ADO - disconnected model or
EXEC ADO - connected model.