Microsoft SQL Server Database stored procedures summary

When you use database stored procedures in a PowerBuilder
application, keep the following points in mind:

• Manipulating stored procedures

  To manipulate database stored procedures, PowerBuilder provides
  SQL statements that are similar to cursor statements.

• Retrieval and update

  PowerBuilder supports retrieval, update, or a combination
  of retrieval and update in database stored procedures, including
  procedures that return no results sets and those that return one
  or more result sets.

• Transactions and stored procedures
  with result sets

  When a procedure executes successfully using a specific connection
  (transaction) and returns at least one result set, no other SQL
  commands can be executed using that connection until the procedure
  has been closed.

• Transactions and stored procedures
  without result sets

  When a procedure executes successfully using a specific transaction
  but does not return a result set, the procedure is no longer active.
  No result sets are pending, and therefore a CLOSE statement is not
  required.

---