Data validation can be built into stored procedures to ensure that business rules are followed and data integrity is maintained. When executing a stored procedure it is only necessary to pass an execute command. This is much more efficient than sending entire SQL statements over the network, especially if there are many users performing the same actions. Let's say we have a table called orders. When deciding to use stored procedures you can follow the rules below.
Stored procedures execute by simply passing an execute command to the database.
This relieves the network from having to pass an entire SQL statement over thus saving bandwidth and response time. Stored procedures are precompiled. Thus all error checking is done at the time it is built. This ensures solid SQL Statements and fast execution time. Stored procedures are fantastic for maintaining data integrity.