Delete Record using Store Procedure

• • Reply

  11 years ago

  by royal ludhiana

  Royal Ludhiana

  Toronto, Canada

  Joined 14 years ago
  Hi, I am a bit confused in deciding whether I should use store procedure for each master table to delete a record depending on primary key. Furthermore, Taking into consideration a master table, say 'StateMaster' with fields StateCode and StateName, I have created these store procedures: - procInsertUpdateState - proc GetState - procDeleteState Do you think I should create these many procedures(more then 5 store procedures) for such a small table. Coz, I'll be having more then 15 such small tables. Any suggestions? Regards, Royal
  Report abuse