Pro-Test available
CREATE PROCEDURE [dbo]. [Output] @acctNbr varchar ( -), --card number @acctpwd1 nvarchar ( -) out,--login password @acctpwd2 nvarchar ( -) out,--Payment password @acctname nvarchar ( -) Out--Membership card Number asbeginSelect@acctPwd1 =acctpswd1, @acctPwd2 =acctpswd2, @acctName =acctname from Base. _member WHERE acctnbr=@acctNbrend/***********************************************************************************declare @return_value int; DECLARE @acctPwd1 varchar;d eclare @acctPwd2 varchar;d eclare @acctName nvarchar; execute @return_value =[dbo ]. [Output] ' 110104183 ', @acctPwd1 out, @acctPwd2 out, @acctName out; SELECT @acctPwd1 as n ' login password ', @acctPwd2 as n ' payment password ', @acctName as n ' user name ', @return_value as n ' return value ' ************************** **********************************************************/
SQL Server stored procedure with output parameters