POS: Execute stored procedure

POS: Execute stored procedure

[Total: 0    Average: 0/5]

This blog post will show you some ways to execute stored procedures from POS using standard API: SqlStoredProcedure and DBUtil from DataAccess DLL.

Let’s imagine we need to execute stored procedure [dbo].[TESTPROCEDURENAME] with 2 input parameters: param1 and param2.

A. Execute Stored procedure that returns data rows

In this case stored procedure returns the set of records.

B. Execute Stored procedure that returns scalar value

In this case stored procedure returns single (scalar) value: number, string, date, etc.