Delete Record using Store Procedure

store procedure , procedure and tables , using store procedures , sql server 2005 , sql server store procedure Toronto, Canada
  • 11 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

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Engineers are all basically high-functioning autistics who have no idea how normal people do stuff.” - Cory Doctorow