带有insert into 语句的存储过程
一个带有insert into 语句的存储过程如下:
CREATE PROCEDURE dbo.HouseInfoPro
@I_InfoSubType int
AS
declare
@TopInfoWhere varchar(500),
@GeneralInfoWhere varchar(500),
@SqlStr varchar(1000)
if exists (select * from sysobjects where id = object_id(N'[dbo].[tempHouseInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tempHouseInfo]
Select I_HouseName,I_HouseMJ,I_HousePic,I_ID,DateAndTime,Sort_Date,LocationType_Num,I_Address,I_HouseUse_Name,I_HouseSort_Name,I_HouseUnit_Price,I_ContactTel into tempHouseInfo From View_HouseInfo where IsShow=1 AND @I_InfoSubType=I_InfoSubType AND DateDiff(second,getdate(),Sort_Date)>=0 Order By LocationType_Num asc,Sort_Date desc
if exists (select * from sysobjects where id = object_id(N'[dbo].[tempHouseInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
Insert into tempHouseInfo(I_HouseName,I_HouseMJ,I_HousePic,I_ID,DateAndTime,Sort_Date,LocationType_Num,I_Address,I_HouseUse_Name,I_HouseSort_Name,I_HouseUnit_Price,I_ContactTel) Select I_HouseName,I_HouseMJ,I_HousePic,I_ID,DateAndTime,Sort_Date,LocationType_Num,I_Address,I_HouseUse_Name,I_HouseSort_Name,I_HouseUnit_Price,I_ContactTel From View_HouseInfo where IsShow=1 AND I_InfoSubType=@I_InfoSubType AND (DateDiff(second,getdate(),Sort_Date)<0 Or Sort_Date Is Null) Order By DateAndTime desc
Select * from tempHouseInfo
GO
返回的RecordSet 做do while
在里面套一个 Set TempRs = conn.execute(...) 时就出错。
当我把存储过程中的 insert 语句注释掉的时候就正常了。
请问如何处理这个情况