Page 1 of 1

Calling an extended stored procedure with output parameters

Posted: Sat 30 Jul 2005 09:11
by Ray Mond
Using SDAC, how can I call an extended stored procedure with output parameters? Thanks.

Ray Mond

Posted: Mon 01 Aug 2005 09:12
by Ikar
Use in TMSQuery the next syntax:

Code: Select all

DECLARE @txt varchar(33)
EXEC xP_getnetname @txt OUTPUT
select @txt
or

Code: Select all

EXEC xP_getnetname :txt OUTPUT
Please see details in MSDN