FRENDS⁴ Common Components : ~SQL.ExecuteStoredProcedure (removed in version 2.0.1.1)

Created by Emma Luukka, last modified by Janne Vuoti on Mar 02, 2016

This task has been removed from NuGet package version 2.0.1.1 onwards. Use SQL.ExecuteCommand instead.

 

This task takes a stored procedure and executes it with the given parameters returning the number of affected rows.

Input Parameters

  • StoredProcedureName
    • The name of the stored procedure that will be executed.
  • Parameters
    • A list of parameters to be executed in the query.
  • ConnectionString
    • The connection string of the database the query is executed to.
  • TimeoutS
    • The timeout of the stored procedure execution in seconds.

Output Result

  • Int32
    • The number of affected rows by the stored procedure

Example Usage

StoredProcedureName [dbo].[TestProcedure]

Parameters ExampleParameter = Parametervalue 1