1. If your software system will not migrate to other database platforms, you can use a lot of memory, there will be no more affected, but if the update basic data table is written during the stored procedure, it may be troublesome. 2. If you are now developing projects may migrate to another database platform, then don't have much dependence on the database. When you migrate, you may not run in a stored procedure written in a database to another database. Now many large companies have advocated them to minimize the dependence on the database. 3. If you are now developing projects will not migrate to other data platforms, but you may rewrite a version in another language. If you are finished with Java, later because for some reason, rewrite a version, so It is necessary to try the stored procedures to write database operations, reuse the original things.
4. Combine permission assignments with stored procedures will enhance system security, which is also a Microsoft recommended approach. 5. Complex database operation stored procedures will increase efficiency and reduce network burden.
