Re: nested stored procs

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Richard Wilde (info_at_rippo.co.ukXXX)
Date: 09/30/04 

Date: Thu, 30 Sep 2004 13:01:10 +0100

Thanks, I thought as much

I was hoping I did not have to trawl through my app to change the parameters
passed to stored proc A

Richard

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:eLYRgQupEHA.896@TK2MSFTNGP12.phx.gbl...
> You can't. You can pass an optional parameter from the outer proc and the
> inner proc will use that
> parameter to determine whether to do the SELECT. Or pass the value out as
> an OUT parameter instead
> of doing a SELECT....
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Richard Wilde" <info@rippo.co.ukXXX> wrote in message
> news:use$9IupEHA.868@TK2MSFTNGP10.phx.gbl...
>> I have a stored procedure A which performs a few inserts and outputs an
>> select @@identity as id
>>
>> I have a stored procedure B which calls stores procedure A
>>
>> However I want to suppress the ouput of stored procedure A inside stored
>> procedure B. I tried using
>>
>> set nocount on
>>
>> but this only suppresses the insert confirmations
>>
>> how do can I do it?
>>
>> PROC B
>> set nocount on
>> exec stored A
>> set nocount off
>>
>>
>
>

Relevant Pages

  • Re: nested stored procs
    ... You can pass an optional parameter from the outer proc and the inner proc will use that ... > I have a stored procedure B which calls stores procedure A ... > However I want to suppress the ouput of stored procedure A inside stored ... > set nocount on ...
    (microsoft.public.sqlserver.programming)
  • SQL Stored Proc - ASP Page - Return Value
    ... I have a SQL Stored Procedure that is I am passing several parameters to and ... The proc is doing a few other things and one ... set nocount off ... adParamInput,, Session)) ...
    (microsoft.public.inetserver.asp.general)
  • Re: nested stored procs
    ... > I have a stored procedure B which calls stores procedure A> ... > However I want to suppress the ouput of stored procedure A inside stored> procedure B. I tried using ... > set nocount on ... > PROC B ...
    (microsoft.public.sqlserver.programming)
  • Persistent Schema-Stability (Sch-S) Locks
    ... locks on this table that linger and stay locked for an extended period ... Locks/Objects view always shows one stored procedure in particular. ... As soon as I kill the process with the Sch-S lock then the CPU usage ... If the "Last TSQL Command Batch" shows this stored proc name all the ...
    (microsoft.public.sqlserver.programming)
  • RE: EXEC Stored Procedure does not work in SSIS task
    ... Your original version had a proc that, before it could do it thing, had to ... Result Set page to map the return to Variables in the SSIS Package. ... Set up your Source adapter and put in your command as: ... The stored procedure sp_GetTrafficData executes another stored procedure the ...
    (microsoft.public.sqlserver.dts)