You answered this by yourself.
No, you shouldn't be using a single SP for all these operations. Try to make your SPs as simple as possible and different SPs for different operations, like SELECT, INSERT, UPDATE, DELETE, etc.
~manoj | email: http://scr.im/m22g
http://sqlwithmanoj.wordpress.com
MCCA 2011 | My FB Page
No comments:
Post a Comment