In the previous chapter, we learned about two printing tools for SQL query: Query Print Layout Design and query for Crystal Reports. This chapter focuses on one of the very special cases for SQL query usages. It is regarding the query used in a special Stored Procedure (SP) called SBO_SP_TransactionNotification. The chapter focuses on the following:
- Why this Stored Procedure is included in the book
- SBO_SP_TransactionNotification overview
- How to work with this SP
- Multiple examples for the SP including its core SQL queries
Stored Procedure is a subroutine available to applications accessing a relational database system. In the case of SAP Business One, the database accessed is Microsoft SQL Server. Stored Procedures are mainly used to simplify the database development process by grouping Transact-SQL statements into manageable blocks.
It might sound like this topic does not fit with this book. However...