create proc fenye
@intDays int ,
@pagesize tinyint,
@pageno int,
@tfield varchar,
@tvalues int
as
declare @RecordNumber int --去掉,号
declare @StartRecord int
select @RecordNumber = @pagesize*@pageno
select @StartRecord=@pagesize*(@pageno-1)+1 begin
select "RecordCount"=count(*) from dinfo order by ID desc
set rowcount @RecordNumber
declare curfenye Scroll Cursor
for
select * from dinfo order by ID desc
open curfenye
fetch absolute @StartRecord from curfenye
while @@fetch_status = 0
fetch next from curfenye
set rowcount 0
/*清场*/
CLOSE curfenye
DEALLOCATE curfenye
end
@intDays int ,
@pagesize tinyint,
@pageno int,
@tfield varchar,
@tvalues int
as
declare @RecordNumber int --去掉,号
declare @StartRecord int
select @RecordNumber = @pagesize*@pageno
select @StartRecord=@pagesize*(@pageno-1)+1 begin
select "RecordCount"=count(*) from dinfo order by ID desc
set rowcount @RecordNumber
declare curfenye Scroll Cursor
for
select * from dinfo order by ID desc
open curfenye
fetch absolute @StartRecord from curfenye
while @@fetch_status = 0
fetch next from curfenye
set rowcount 0
/*清场*/
CLOSE curfenye
DEALLOCATE curfenye
end
但是我改以后,又弹出个新错误来
*************************
错误:8126:列名dinfo.ID在OEDER by子句中无效,该列未包含在聚合函数中,并且没有Group by 子句
************************
这个错误又是什么意思
我把那个order by ID desc还是没有错误了
没问题了是我在统计值的时候也加了个order 语句
那个变量问题???