Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Single Point of Administration Expand / Collapse
Author
Message
Posted Tuesday, August 15, 2006 7:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

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