帮我优化一下这个存储过程

[goodflash]

declare @tempsql varchar(8000)

begin
set @tempsql='select top' +str(@temp_ipage)+ ' * from table1 where id=1 and id not in (select top '+str(@temp_spage)+' id from table1 where id=1) order by id desc'
execute(@tempsql)
end

如果@temp_spage的数量特别多，效率就会低，而且@tempsql的长度8000也不够用。。。有什么办法实现类似功能？？？

[yehuazi]

exec('select top' +str(@temp_ipage)+ ' * from table1 where id=1 and id not in (select top '+str(@temp_spage)+' id from table1 where id=1) order by id desc')

[pengdali]

declare @tempsql1 varchar(8000)
declare @tempsql2 varchar(8000)

begin
set @tempsql1='select top' +str(@temp_ipage)+ ' * from table1 where id=1 and id '
set @tempsql2='not in (select top '+str(@temp_spage)+' id from table1 where id=1) order by id desc'
execute(@tempsql1+@tempsql2)
end

[erigido]

占座学习。

[goodflash]

up...

怎么样用其他语句实现类似功能？

比如 ... and id>...
不用not in

[yangvxin1]

占座看看

[yangvxin1]

占座学习，哈哈