在sqlserver2005中能正常的执行通过,但是就是在网页分页的时候出现错误。
提示")"附近有语法错误
请教...@Proc_Orderby bit, --排序
@Proc_Pagesize int, --页面大小
@Proc_Page int , --当前页
@Proc_Pages int output --总页数if @Proc_Orderby=0
set @sql='select top '+cast(@Proc_Pagesize as varchar)+' * from Logcount where logid>(select max(logid) from(select top '+cast(@Proc_pagesize*(@Proc_Page-1) as varchar)+' logid from Logcount order by logid asc)) order by logid asc'
提示")"附近有语法错误
请教...@Proc_Orderby bit, --排序
@Proc_Pagesize int, --页面大小
@Proc_Page int , --当前页
@Proc_Pages int output --总页数if @Proc_Orderby=0
set @sql='select top '+cast(@Proc_Pagesize as varchar)+' * from Logcount where logid>(select max(logid) from(select top '+cast(@Proc_pagesize*(@Proc_Page-1) as varchar)+' logid from Logcount order by logid asc)) order by logid asc'
set @newProc_pagesixe=(@Proc_pagesize*(@Proc_Page-1);set @sql='select top '+cast(@Proc_Pagesize as varchar)+' * from Logcount where logid>(select max(logid) from(select top '+cast(@newProc_pagesixe as varchar)+' logid from Logcount order by logid asc)) order by logid asc'
set @sql='select top '+cast(@Proc_Pagesize as varchar)+' * from Logcount where logid>(select max(logid) from(select top '+cast(@Proc_pagesize*(@Proc_Page-1) as varchar)+' logid from Logcount order by logid asc) as #temp) order by logid asc'drop table #temp
set @sql='select top '+cast(@Proc_Pagesize as varchar)+' * from Logcount where logid>(select max(logid) from(select top '+cast(@Proc_pagesize*(@Proc_Page-1) as varchar)+' logid from Logcount order by logid asc) as #temp) order by logid asc'