Stored Procedure

hi dipak,

agree with vulpes, just want to add
it diffucult to handle versionof SP.
And Difficult to debug.

hope this help.

0

Dipal Choksi14y ago

Here is are articles detailing the disadvantages of SPs -
http://www.spoiledtechie.com/post/Whats-up-with-Stored-Procedures-these-days.aspx http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx
Here is another good discussion.This has links to additional resources/information too..

0

Vulpes14y ago

The only disadvantage of stored procedures that I can think of is lack of portablility.

In other words, an SP written for one RDBMS may not work with another. This may be because of differences in the SQL dialects used or because one RDBMS supports features which another one does not.

0