Re: Language Features I'd Like To See

From: Kyle A. Miller (kyle#REMOVE_at_millerdevelopment.info)
Date: 03/11/05 

Date: Fri, 11 Mar 2005 12:03:41 -0600

Don Strenczewilk wrote:
> Well yeah, there should be a rule that no stored proc or trigger should be
> allowed to call another stored proc. Makes things a lot simpler. :)

Our application has stored procedures calling other stored procedures.
This allows customers to write their own custom code separate of our
own. For example, we might have a procedure called DoCalcs which will
call a stored procedure called DoCustomCalcs at the end of its
execution. Gives the customers a sandbox to play in without affecting
the core product.

Relevant Pages

  • Re: Debating Views vs Stored Procedures for reports and applications
    ... I choose usp's (user stored procedures) because I can send back multiple ... ProductName from dbo.Products p where exists (select null ... Now I use nested repeaters alot with basic reports. ... Since I have a list of all Customers, I'm able to display all Customers ...
    (microsoft.public.sqlserver.programming)
  • Re: Multiple Tables as SqlDataSource
    ... One of the easiest ways to do this is to create your own stored procedures for each of the CRUD steps, Read, Update and Delete). ... But, if you are taking the time to write hand coded SQL, why not take the step of abstracting your database schema from your code through stored procedures? ... I want to have an editable GridView displaying all the data and being able to add, edit and delete customers. ... Creating custom BusinessObjects and custom BusinessObject adapters is very much work and I found no good sample for such a case, where everything is supported, including sorting, etc. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Newbie: Stored Procedures and Or Datasets ?
    ... > be a concensous that Stored Procedures are the most effective means to ... > mena less database access, can be optimised by the DBMS or Database ... you can use Stored Procedures just as easily as Dynamic Sql - in it's ... statement is virtually identical to calling a stored proc. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE:Any way to debug using SQL SP
    ... I am a newbie to QA debugger. ... with stored procedures. ... I have created a following stored proc which in turn ... Basically my intention is to debug the user ...
    (microsoft.public.sqlserver.server)
  • Re: Brackets and special characters -- Brain Teaser
    ... You might be able to script out the Stored Procedures and do a search ... > The system is designed to use temp tables. ... I am guessing this design was for a stateless ... stored proc. ...
    (microsoft.public.sqlserver.programming)