Re: VBSCript execute MS SQL Stored Procedure Return Value

Yas wrote:
On 17 Sep, 20:59, "Bob Barrows [MVP]" <reb01...@xxxxxxxxxxxxxxx>
wrote:
Yas wrote:
Hello,

This may help you with the proper
terminology:http://www.google.com/groups?hl=en&lr=&c2coff=1&selm=OgYK94SgEHA.4092...
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a
quicker response by posting to the newsgroup.

Hi, actually I changed/corrected the Procedure name but forgot to
update it in the post. :-)

Anyway, its a simple stored procedure that takes 1 parameter and
returns the value for that Parameter. It searches for the given
parameter name in a table and returns just 2 columns, the parameter
name and parameter value.

CREATE PROCEDURE my_getParam
@paramName nvarchar(50)
AS


Did you read my post about how to return data from procedures? Is your
intent to return the value using @paramName? Or are you returning the
results as a Select statement? If you don't understand my question, you had
best post the rest of your procedure script.

--
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: Data Project - Running SP via ADO
    ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Search Date and Time
    ... in a single Date/Time field. ... Microsoft MVP - ASP/ASP.NET ... Please reply to the newsgroup. ... This email account is my spam trap ...
    (microsoft.public.access.queries)
  • Re: Updating column property on table gives error
    ... in code instead of when the append happens. ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Writing a GUID to a SQL table
    ... I strongly suspect that it is SQL Server, ... >> Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: using ado drivers with 64 bits software
    ... experts in one of the Access groups. ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)