Attribute Details: SqlReturnType
 Back


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.



POTENTIAL VALUES

FirstRow
RowsAffected




PARENT ELEMENTS

Click element to drill down for more information.

Execute.SQL Procedure.SQL


 Back to top