Re: Return only last dataset from involved SP?

From: Stephen Russell (srussell_at_notat_lotmate.com)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 13:48:00 -0600

"Adam Machanic" <amachanic@air-worldwide.nospamallowed.com> wrote in message
news:%23XvLth2EEHA.3180@TK2MSFTNGP12.phx.gbl...
> Does your proc have SET NOCOUNT ON as the first statement?

Yes, not avail.

Thanks. 

-- 
Stephen Russell
S.R. & Associates
Memphis TN
901.246-0159
Steve says get rid of the notat_ to send him a reply!

Relevant Pages

  • Re: Stop DTS execution
    ... Include SET NOCOUNT ON as the first statement in your proc: ... CREATE PROC StorProc ... >>SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Return recordset from update sp
    ... What you need to do is to add SET NOCOUNT ON as a very first statement into ... Create Proc zusp_GenerateRptID ... >I am trying to get a recordset returned from a stored proc> ...
    (microsoft.public.data.ado)
  • Re: Simple Stored Procedure funktioniert mal und funktioniert mal nich
    ... Deine PROC gibt keinen RETURN-Value zurück sondern ... > Ein Return-Value in einer SP ist immer vom Datentyp int ... > Eine Return-Variable sollte in einer SP immer deklariert sein. ... > SET NOCOUNT OFF ...
    (microsoft.public.de.sqlserver)
  • Re: Bcp and temp tables
    ... Here is the proc: ... bcp "SET FMTONLY OFF EXEC pubs.dbo.Kristoffer" queryout ... without SET NOCOUNT ON with the same results. ... > Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Simple Stored Procedure funktioniert mal und funktioniert mal nich
    ... Ein Return-Value in einer SP ist immer vom Datentyp int ... Eine Return-Variable sollte in einer SP immer deklariert sein. ... CREATE PROC dbo.myProc ... SET NOCOUNT OFF ...
    (microsoft.public.de.sqlserver)
Loading