Çë½ÌSQLת»»×Ö·ûÎÊÌâ - .NET¼¼Êõ / ASP.NET

SQL code:

declare @pagecount int
declare @sql varchar(500)
set @pagecount=10
set @sql='select top '+cast(@pagecount as varchar(10))+' * from book order by [ID] desc'
exec (@sql)



Ö´Ðлᱨ´í¡°ÔÚ½« varchar Öµ 'select top 10 * from book order by [ID] desc' ת»»³ÉÊý¾ÝÀàÐÍ int ʱʧ°Ü¡£¡±

ÇëÎÊÕâÀïÔõôƴ×Ö·û£¿Èç¹û±íÃûÊDZäÁ¿ÇëÎÊÔõôƴд£¿
Ë­ÓÐSQLÆ´×Ö·ûµÄ×ÊÁÏ£¿·¢ÍøÖ·£¬Ð»Ð»

---

¸ÕÊÔÁËÏ£¬ÉÏÃæÕýÈ·£¬µ«ÏÂÃæÕâ¶ÎÖ´ÐеÄʱºò³öÎÊÌ⣿

´´½¨´æ´¢¹ý³Ì
SQL code:

create proc book_page3
@page int,@pagecount int
as
declare @sqls varchar(500)
declare @page2 int
declare @counts int
declare @sqlc int
declare @sqll int

select @counts=count(*) from book
set @sqlc=@counts/@pagecount+1
if @page<=@sqlc and @page<>0
begin
if @page<>1
begin
set @page2=@pagecount*(@page-1)
select top (@pagecount) * from book where [ID]<(select min(ID) from (select top (@page2) ID from book order by [ID] desc)b) order by [ID] desc
end

else
begin
set @page2=@pagecount*@page
select top (@pagecount) * from book order by [ID] desc
end
end
else
begin
set @sqll='select top '+cast(@pagecou