文章分类 -  转载文章

摘要：select top 页大小 *from table1 where id> (select max (id) from (select top ((页码-1)*页大小) id from table1 order by id) as T ) order by id 从publish 表中取出第 n 条到第 m 条的记录： SELECT TOP m-n+... 阅读全文

摘要：这样写是错的 declare @qa nvarchar(200)declare @i intdeclare @sql nvarchar(255)set @i = 1while @i <= 5 begin set @sql = 'select q' + convert(nvarchar(2), @i) + ' from ImportSurveyInfo' set @i = @i + 1 decl... 阅读全文