what is a sproc?
May 8, 2009
Stored procedure is just something like a script or batch that is stored in in the database rather than in a separate file. sproc can have input/output parameters and return values.
why use sproc:
- call it
- security
- erpformance
How to:
- create/drop a sproc
- declare parameters
- flow control (if…else)
- case
- return values
- loop with WHILE
- waitfor
- dealing with errors
