There are more reasons than this for writing stored procedures. 1. Security - with stored procedures you do not have to give permissions to the underlying tables. This is becoming a bigger issue with Sarbanes-Oxley, HIPAA and other privacy regulations.
2. Cached query plans. 3. SQL injection. Just to name a few. Tim Flory Sr Programmer Analyst Phone: 216.464.2244 ext. 229 www.medquist.com This electronic mail transmission contains confidential information intended only for the person(s) named. Any use, distribution, copying or disclosure by another person is strictly prohibited. If you are not the intended recipient of this e-mail, promptly delete it and all attachments. > Also, please take into account that any db vendor really > likes you to write procs, as these aren't portable, so the more > procs an app has, the more certain the db vendor is that the > application developer stays with the database vendor. > > FB > > =================================== > This list is hosted by DevelopMentor® http://www.develop.com > > View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
