不知道妳為什麽要這樣的寫法,總是看著怪怪的,,,
妳直接
create?PROC?my_pro?--創建存儲過程 @in?DECIMAL(19,4),@out?DECIMAL(19,4)?OUTPUT
AS
SET?@out=@in
SELECT?@out
GO
exec?my_pro?'252.8',0
這樣試下吧,,,,
妳要非要用妳那種寫法,可以
alter?PROC?my_pro?--創建存儲過程 @in?DECIMAL(19,4),@out?DECIMAL(19,4)?OUTPUT
AS
SET?@out=@in
RETURN?@out
GO
DECLARE?@RC?DECIMAL(18,2)
exec?my_pro?'252.5',@RC?OUTPUT
select?@RC?AS?a