The output parameter in this stored procedure is only there to reduce the
overhead of returning a full resultset (which translate into a Recordset in
ADO) for a single value by returning this single value as a parameter
instead. This is similar to the DLookUp function and this SP can be
replaced by a DLookup() call or a simple Select statement:
DLookUp ("CustName", "CustomerDB", "CustID=" & [CustID])
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Frank" <frank288[ at ]gmail.com> wrote in message
news:1130506671.347453.313960[ at ]g49g2000cwa.googlegroups.com...
[Quoted Text] > Hi all,
>
> Is it possible to port a SQL Server Stored Procedure with Output
> parameter to Microsoft Access Query?
>
> Currently, i'm having problem porting the below SQL Server stored
> procedure to MS Access
>
> Create Procedure myProcedure
> (
> [ at ]CustID int
> [ at ]CustName nvarchar(50) OUTPUT
> }
> As
> Select
> [ at ]CustName = CustName
> From
> CustomerDB
> Where
> CustID = [ at ]CustID
>
>
> Thanks for helping.
>
|