CREATE PROCEDURE [Ph_SuminQty]
@dltbl varchar (50), //表名
@dlId int,
@count float out
@sumqry int out
AS declare @sql varchar (2000)
select @sql='select @sumqty = sum(qty) from '+@dltbl+' where RelBilldlId='+ltrim(str(@dlId))
--print @sql
exec (@sql)
@dltbl varchar (50), //表名
@dlId int,
@count float out
@sumqry int out
AS declare @sql varchar (2000)
select @sql='select @sumqty = sum(qty) from '+@dltbl+' where RelBilldlId='+ltrim(str(@dlId))
--print @sql
exec (@sql)
@dltbl varchar (50), //表名
@dlId int,
@count float out
@sumqty int output
AS declare @sql varchar (2000)
select @sql='select @sumqty=sum(qty)from '+@dltbl+' where RelBilldlId='+ltrim(str(@dlId))
--print @sql
exec (@sql) declare @sum int
exec Ph_SuminQty ……,……,……,@sum output
@dltbl varchar (50), //表名
@dlId int,
@count float out
AS declare @sql nvarchar (2000)
select @sql=N'select @sum = sum(qty) from '+@dltbl+' where RelBilldlId='+ltrim(str(@dlId))
exec sp_executesql @sql,N'@sum float output',@count output