通过变量表返回记录集为什么不可以呢
CREATE PROCEDURE [Test_Production] (@CompanyId varchar(20),@WorkDateFrom datetime,@WorkDateTo datetime,@Results varchar(200) out)
AS
declare @Product table (WorkDate datetime,TypeName varchar(200),Amount float)
insert into @Product(WorkDate,TypeName,Amount) select WorkDate,TypeName,Amount from v_Production where CompanyId=@CompanyId and WorkDate>=@WorkDateFrom and workDate<=@WorkDateTo
----1
select * from @Product
----2
-- select * from v_Production
上述存储过程中如果用1即变量表来返回记录集,提示说记录集关闭
只有用2即物理表查询返回记录集才没问题
哪位高人指点一下