You can specify the following SQL DML statements in an SQL procedure.
- ABORT
- BEGIN TRANSACTION
- CALL
- COLLECT STATISTICS (QCD Form)
- COMMENT
- COMMIT [WORK]
- DECLARE CURSOR (selection form)
- DELETE (all forms)
- DROP STATISTICS (QCD Form)
- END TRANSACTION
- INSERT
- MERGE
|
- ROLLBACK
- SELECT (only in cursors)
You cannot specify row-returning SELECT requests in dynamic SQL that is written using the DBC.SysExecSQL procedure.
- SELECT AND CONSUME TOP 1
(only in non-updatable cursors)
- SELECT INTO
You cannot specify row-returning SELECT INTO requests in dynamic SQL that is written using the DBC.SysExecSQL procedure.
- SELECT AND CONSUME TOP 1 INTO
- UPDATE (all forms)
|