create proc getproductdata
(
@productID int,
@productName nvarchar(40) output,
@productPrice money output
)
as
select @productName=productName,@productPrice=unitprice
from products
where productID=@productID
go---调用:
declare @a nvarchar(40),@b money
exec getproductdata 1 @a out,@b outselect @a,@b
(
@productID int,
@productName nvarchar(40) output,
@productPrice money output
)
as
select @productName=productName,@productPrice=unitprice
from products
where productID=@productID
go---调用:
declare @a nvarchar(40),@b money
exec getproductdata 1 @a out,@b outselect @a,@b
exec getproductdata 1,@out1 output,@out2 output
exec getproductdata 1 @a out,@b outselect @a,@b
exec getproductdata 1 @var1 output,@var2 output
select @var1,@var2