call stored procedure with input and output parameter

[nisha23]

I have created an extended stored procedure which I want to call from lookup, is it possible and how

I am giving my command like this which is not working
xp_TestVal ?

if I give like constant
xp_TestVal 'abc'

this extended stored procedure is returning one value as varchar(30) and input parameter is also varchar(30)

 

[SQLDenis]

Are you talking about an output parameter?
If so this is how you do it

DECLARE @ThisVar varchar(30)
--@ThatVar is the output parameter in the procedure
EXECUTE xp_TestVal 'abc', @Thatvar = @ThisVar OUTPUT

http://sqlservercode.blogspot.com/