问题如下
我用identity 在sybase中作了分页

但如果表中有 identity 字段这个分页就会报错.

set rowcount 2
SELECT LOGSID,FILENAME,CREATEDATE,USERID,LINAGE,DESCRIPTION,sybid=identity(12) into #temptable1 FROM
STALOG WHERE tablename='QUESTIONS' or tablename='QUESTION_CHOICE' or tablename='QUESTION_FILL'
or tablename='QUESTION_MATCH' or tablename='Q_SUBJECTIFY' or tablename='MA_QUPOOL' ORDER BY LOGSID

select * from #temptable1 where sybid>0 and sybid <=2
set rowcount 0
drop table #temptable1 commit transaction

例子如上, 其中 STALOG表的 LOGSID字段是 identity的
报的错误是
Attempting to add a new identity field to a table '#temptable1', via select into, which would have a field 'LOGSID' that inherits the identity property.

请问怎么解决呢 ?

我的邮箱是 w-bo@neusoft.com

解决办法如下
set rowcount 2
SELECT convert(vchar,logsid) logsid ,FILENAME,CREATEDATE,USERID,LINAGE,DESCRIPTION,sybid=identity(12) into #temptable1 FROM
STALOG WHERE tablename='QUESTIONS' or tablename='QUESTION_CHOICE' or tablename='QUESTION_FILL'
or tablename='QUESTION_MATCH' or tablename='Q_SUBJECTIFY' or tablename='MA_QUPOOL' ORDER BY LOGSID

select * from #temptable1 where sybid>0 and sybid <=2
set rowcount 0
drop table #temptable1 commit transaction

这样就行了,把identity类型的转换下,在放到临时表里.