TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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?
Reply
Answers (
3
)
DELETE and TRUNCATE Commands in SQL Server
Implicit Inner Join in SQL server