baskaran chellasamy

baskaran chellasamy

  • NA
  • 114
  • 150.4k

Is one Store procedure for all dml satatement best?

Jul 28 2012 11:25 AM
Hi Friends,

 My project is depend with database for lot of implementation. i have many tables  that is need to be inserted,updated,selected and delete the record. i want to create one single procedure for all dml funtions(insert,update,delete,select).If i creating this one procedure for all  dml function then no need to create a more procedure for each and everything. and it reduce code also. Is My method is correct for implementation or  i need to create separate procedure for all dml funciton likewise all table. please help me . Which is the best?


Answers (3)