如下:我想調用過程SPdata,其中有時間參數,想返回過程處理后得到的記錄集.CREATE PROCEDURE SPdata
@startdate varchar(22),
@enddate varchar(22),
AS
Select * from Users1 Where intime>=@startdate and intime <=@enddate
@startdate varchar(22),
@enddate varchar(22),
AS
Select * from Users1 Where intime>=@startdate and intime <=@enddate
在你建立的过程AS 后开始加入一句 set nocount on
还有,你过程的结果只有一个返回集,如果有多个,只能返回一个create procedure try (@D nvarchar)
as set nocount on --加这一句select @D as A into #tmpAselect @D + 'B' AS B into #tmpB select B from #tmpB select A from #tmpAgo以上语句中,ADO只返回select B from #tmpB 的结果
切记切记
set nocount on 真的有效,多謝!
有辦法讓他返回的是最后一個Select的語句嗎? 如:select A from #tmpA
如上面 jdcxf(chenxf)所講的如:select A from #tmpA ?