Re: Return value from Stored Procedure

Light wrote:
CREATE Procedure NewCompany
(
@varCompanyName varchar (50) = null,


@RETURN_VALUE int OUTPUT
)
As

You need to add "SET NOCOUNT ON" to this procedure - right here as a matter
of fact.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Random ADODB.Recordset error 800a0cc1 ?
    ... Per Salmi wrote: ... > SET NOCOUNT OFF ... This will not prevent your counters from working. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: array/recordset?
    ... > with regards to the nnn - does it matter what size i use here? ... The DefinedSize argument should be ignored for this datatype, ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: Help - stored procedure not returning a recordset
    ... The SET NOCOUNT ... setting will revert to the original setting when the stored procedure ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: SQLServer access from Excel / ADO
    ... re-compile the proc with SET NOCOUNT ON ... And here is the real reason: ... garbage Microsoft makes) ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)