|
|
|
|
|
|
by vp89
4067 days ago
|
|
|
The same way you test any other piece of code. A stored procedure is just an encapsulation of logic, with inputs and possibly state changes and/or outputs. Expected/actual asserts can be coded in SQL. The code tends to be verbose, but some RDBMS have evolved to include more powerful language features. It's probably possible in almost all RDBMS, but certainly easier in some than others. |
|
|