>I've seen in an article that using Output parameters is much faster in performance than returning a recorset if you are returning single value or row of data.
>
>Any example code on how to create output parameter in a stored procedure that returns for example account,telno and address.
>
>TIA.

CREATE PROC getstuff
(@account varchar(20) OUTPUT
,@telno varchar(10) OUTPUT
,@address varchar(50) OUTPUT
,@pk int
)
AS

SET NOCOUNT ON

SELECT @account = account
,@telno = telno
,@address = address
FROM MyTable
WHERE pk = @pk

RETURN


BOb