Declare @Page int,@Page_Size int,@ID1 int,@ID2 int,@SQL_String Nvarchar(2000); Set @Page=1;
Set @Page_Size=35; Set @ID1=((@Page*@Page_Size)-@Page_Size);
Set @ID2=(@Page*@Page_Size); Set @SQL_String=' Select * From 表 Where ID> ' + cast(@ID1 as varchar) + ' And ID<= ' +cast(@ID2 as varchar) exec (@SQL_String)
Set @Page_Size=35; Set @ID1=((@Page*@Page_Size)-@Page_Size);
Set @ID2=(@Page*@Page_Size); Set @SQL_String=' Select * From 表 Where ID> ' + cast(@ID1 as varchar) + ' And ID<= ' +cast(@ID2 as varchar) exec (@SQL_String)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货