declare @t int--总计
declare @s int--剩余
------
------select @t=sum(TotalNum) ,@s=sum(Numed) from Tools
为什么@t,@s 获得不了值啊?
declare @s int--剩余
------
------select @t=sum(TotalNum) ,@s=sum(Numed) from Tools
为什么@t,@s 获得不了值啊?
declare @s int--剩余
------select @t=0,@s=0select @t=sum(TotalNum) ,@s=sum(Numed) from Toolsselect @t,@s
select @t,@s你前面做的只是赋值而已
declare @t int--总计
declare @s int--剩余
------
------select @t=sum(TotalNum) ,@s=sum(Numed) from Tools --赋值
select @t,@s --获取
1楼的不行啊
@name int,
@xinghao int,
@province nvarchar (50),
@em int,
@type int
AS
declare @t int--总计
declare @s int--剩余
------select @t=0,@s=0select @t=sum(TotalNum) ,@s=sum(Numed) from Toolsselect @t,@s
BEGIN
SET NOCOUNT ON;
select @t=sum(to_TotalNum) ,@s=sum(to_Numed) from Tools where to_type=@typeif exists(select to_id from tools where to_type=@type)
begin
select @to_Numed=to_Numed,@to_TotalNum=to_TotalNum from tools where to_type=@type
update tools set to_TotalNum=@t+@to_TotalNum ,to_Numed=@s+@to_Numed where to_id=@tid
end
else
begin
。
end
1 12 11 斧子 1
2 10 10 改锥 1
大概这样吧
或者
declare @s int=null--剩余
declare @s int--剩余select @t=sum(TotalNum) from Tools
select @s=sum(Numed) from ToolsSELECT @T,@S
试试?应该不是这的原因
declare @t int--总计
declare @s int--剩余
------select @t=0,@s=0select @t=sum(TotalNum) ,@s=sum(Numed) from Toolsselect @t,@s
这部分试试,我试了试我的,没问题啊~