Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Single Point of Administration Expand / Collapse
Posted Tuesday, August 15, 2006 7:46 AM


Group: General Forum Members
Last Login: Monday, June 11, 2007 7:09 AM
Points: 131, Visits: 1

I try to minimise code by creating new stored procedures that can be called from more than one other SPROC.  So, sometimes, less code but more SPROCS are the answer. 

In my current application I have created what I call twin SPROCS.  These are identical except for the substitution of one table name with another in the select statement used for an insert.  Should I find a way of not doing this?  Can I have conditions in the code that would enable an alternative approach.  Maybe I should consider using the the 'when' command or something. 

Post #301843
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse