分页存储调用出错

jueljust

免费乐捐，感谢支持

有一个分页存储过程如下

CREATE PROCEDURE GetDataByPage
(
    @SqlStr         varchar(8000),
    @PageSize       int,
    @CurrentPage    int
)
AS

DECLARE @FirstRec int, @LastRec int,@dt varchar(10)

BEGIN
  SELECT @FirstRec = (@CurrentPage - 1) * @PageSize
  SELECT @LastRec = (@CurrentPage * @PageSize + 1)
  SELECT @dt= substring(convert(varchar,rand()),3,10)
  
  SELECT @SqlStr = stuff(@SqlStr,charindex(' FROM ',upper(@SqlStr)),6,' INTO tempdb..Paging'+@dt+' FROM ')
  EXECUTE (@SqlStr)
  SELECT @SqlStr = 'ALTER TABLE tempdb..Paging'+@dt+' ADD RID numeric(10) IDENTITY PRIMARY KEY'
  EXECUTE (@SqlStr)
  
  SELECT @SqlStr = 'SELECT Count(*) From tempdb..Paging'+@dt
  EXECUTE (@SqlStr)
  
  SELECT @SqlStr = 'SELECT * FROM tempdb..Paging'+@dt+' WHERE RID >; '+convert(varchar,@FirstRec)+' and RID < '+convert(varchar,@LastRec)
  EXECUTE (@SqlStr)
  
  SELECT @SqlStr = 'DROP TABLE tempdb..Paging'+@dt
  EXECUTE (@SqlStr) 
  
END

调用时，输入
>GetDataByPage('SELECT * FROM DateTime', 1, 1)
>go

返回消息
Msg 102, Level 15, State 1:
Line 1:
Incorrect syntax near 'SELECT * FROM DateTime'.

请问哪里出错了

[此贴子已经被作者于2006-4-29 10:59:09编辑过]

jueljust

解决了，调用语法不对，去掉括号就行了

dingon

你的原始表里没有identity字段吧????

如果有这个自增长字段,如何翻页呢?????一张表不允许两个identity字段的!!!!

头都大了.ft

sybasefa

我分页也是用的这个存储过程，在java中调用，可是我的SQL语句是

"select EntRegNO,EntName,QYLX,EntStatus,BuItem from td_vobject where 1=1 and EntName like '%管理有限公司'"

执行的时候报：com.sybase.jdbc2.jdbc.SybSQLException: The identifier that starts with '"set rowcount 100 select EntR' is too long. Maximum length is 28.这个错误，是什么原因啊，请高手指教，小弟第一次用sybase数据库，谢谢