June 15, 2011 at 10:38 am
is it advisable to have single procedure for each reference master's Insert,update and delete operations.
June 15, 2011 at 11:08 am
Yes following the lines of your previous discussion it is preferable to have each module of code do one and only one thing. If you have combined them you have to pass which operation you want to perform. In addition to the train wreck the code would resemble you would have to do a mountain of validation based on which operation you are trying to perform. Follow the KISS principal and make your life easier.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply