如楼上同学所说:是可以返回一个结果集的 create procedure 入库表单流水帐(@selday char(4),@selmonth char(4)) as SELECT SUM(入库表单.入库数量) AS 当日入库数量, 入库表单.产品代码,sum(入库表单.入库数量)*(产品信息表.现行价) as 金额 FROM dbo.入库表单, dbo.产品信息表 where (dbo.入库表单.产品代码 = dbo.产品信息表.产品代码) and (day(dbo.入库表单.入库日期)=@selday) and month(dbo.入库表单.入库日期)=@selmonth GROUP BY DAY(dbo.入库表单.入库日期), dbo.入库表单.产品代码,产品信息表.产品代码,产品信息表.现行价
当然可以得到数据集了,就象普通的Select一样 你这样写 select @return1=field1 ,@return1=field1 from TableName 当然只得到一条记录了,而且是最后一条,因为@return1是个变量,只能保存一个值,直接写 select field1 from TableName 就可以了
create procedure 入库表单流水帐(@selday char(4),@selmonth char(4)) as
SELECT SUM(入库表单.入库数量) AS 当日入库数量, 入库表单.产品代码,sum(入库表单.入库数量)*(产品信息表.现行价) as 金额
FROM dbo.入库表单,
dbo.产品信息表 where (dbo.入库表单.产品代码 = dbo.产品信息表.产品代码) and (day(dbo.入库表单.入库日期)=@selday) and month(dbo.入库表单.入库日期)=@selmonth
GROUP BY DAY(dbo.入库表单.入库日期), dbo.入库表单.产品代码,产品信息表.产品代码,产品信息表.现行价
你这样写
select @return1=field1 ,@return1=field1
from TableName
当然只得到一条记录了,而且是最后一条,因为@return1是个变量,只能保存一个值,直接写
select field1 from TableName 就可以了