create PROC C_sum(@N int)
as
begin
return ([email protected])[email protected]/2
end
declare @x1 int
set @x1=0
exec C_sum 10,@x1 output
print @x1
----------------
无法在 sysdepends 中添加当前存储过程所对应的行,因为缺少该存储过程所依赖的对象 'C_sum '。仍将创建该存储过程。
------解决方案--------------------
--try
create PROC C_sum(@N int,@m money output)
as
begin
set @m= ([email protected])[email protected]/2.0
end
go
declare @x1 money
exec C_sum 10,@x1 output
select @x1
drop proc C_sum