Sets the return type for a Procedure.SQL element.
"RowsAffected" is useful for determining the number of rows changed by the SQL command. The supported SQL commands are UPDATE, INSERT, and DELETE.
Access this value with an @Procedure "RowsAffected" token, for example:
@Procedure.myProcedureId.RowsAffected~
"FirstRow" returns the first row of a rowset returned by the SQL command. Access the values of the first row with @Procedure tokens. For example:
@Procedure.myProcedureId.someColumnName~
"RowsAffected" is the default value for SqlReturnType. |