I am new to an environment (located in Central Asia) that
relies heavily on Stored Procedures on SQL 7. It is clear
that many of the problems we experience are from poor
update and recovery controls of these SPs.
What options are there to implementing Source Control on
MS Stored Procedures?
SP Source Control Options ... I am new to an environment (located in Central Asia) that ... relies heavily on Stored Procedures on SQL 7. ... update and recovery controls of these SPs. ... MS Stored Procedures?... (microsoft.public.sqlserver.security)
Re: Help with Stored Procedure ... I did mean stuff like system stored procedures (even ... build the query, compile it, and optimize it, then, then this is less ... very not easy using dynamic sql.... (microsoft.public.sqlserver.programming)
Re: choices regarding where to place code - in the database or middle tier ... Sure, the DBMS is a good place for simple referential integrity constraints, ... to 4 separately-running-but-pipelined stored procedures,... A typical user would enact a 100 or so business functions per day. ... own stored procedures' by storing the SQL for every business query in the DBMS ... (comp.lang.java.databases)
Re: choices regarding where to place code - in the database or middle tier ... Sure, the DBMS is a good place for simple referential integrity constraints, ... to 4 separately-running-but-pipelined stored procedures,... A typical user would enact a 100 or so business functions per day. ... own stored procedures' by storing the SQL for every business query in the DBMS ... (comp.lang.java.programmer)