Calling an extended stored procedure with output parameters

[Ray Mond]

Using SDAC, how can I call an extended stored procedure with output parameters? Thanks.

Ray Mond

[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