34,589
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE [dbo].[ps_test]
@result decimal(18, 2) output
AS
BEGIN
set @result =5.21
END
go
declare @i dec(18,2)
exec [dbo].[ps_test] @i output
select @i
go
drop proc [dbo].[ps_test]
/*
---------------------------------------
5.21
(1 row(s) affected)
*/