SQL Server - Stored Procedure
In this article
Overview
You can use this Snap to execute a stored procedure in a SQL Server database and writes the values of OUT parameters to the output view.
Starting from SQL Server 2008, the result set from a Transact-SQL statement or stored procedure includes the count of the number of rows affected. This Snap fails to parse this extra information and may display an error (such as Failed to process result set)
. To fix the issue, add the following line to the stored procedure to turn off the output of the count: SET NOCOUNT ON
Snap Type
SQL Server - Stored Procedure is a Write-type Snap that executes an SQL Server stored procedure.
Prerequisites
None.