CREATE procedure tong1 @nlsum int output as begin set @nlsum=(select sum(nl) from table22) end

请问@nlsum 作为输出参数~在查询分析器里怎么把@nlsum的值print出来！ 格式我忘记了 ！

execute tong1
declare @nlsum
begin
set @nlsum=(select sum(nl) from table22)
print @nlsum
end
我这样写 老是报错！  

CREATE procedure tong1 @nlsum int output as begin set @nlsum=(select sum(nl) from table22) print @nlsum end

execute tong1 1

CREATE procedure tong1
@nlsum int output
as
begin
set @nlsum=(select sum(nl) from table22)
end
---------
declare @ko varchar(10)
SET @ko='23'
exec tong1 @ko output
select @ko
事先先赋值给@ko ,让它去调用tong1的存储过程，返回就可以了。。。

这个用过程不是太好,最好用自定义函数.