摘要：方法一:With [TempTable] As (Select [FieldID], Row_Number() Over(Order By [FieldID]) RowNumber From [Target])Update [Target] Set [FieldID] = RowNumber方法二：... 阅读全文

摘要：2000及2005通用分页。1:3次排序分页。select * from (select top 10 * from (select top 20 * from SourceTable order by [id] asc) as TempTable order by [id] desc) as RetTable order by [id] asc2：双TOP分页。select top 10 * from SourceTable where [Id] not in( select top 10 [Id] from SourceTable )3：MAX分页。select top 10 * from 阅读全文

摘要：/*一般游标的用法*/Set RowCount 10Declare @Name varchar(50) --声明存储变量Declare Curs CurSor For --声明游标,并指向数据源 Select Name from SysObjects --数据源 Open Curs --打开游标 Fetch Next From Curs Into @Name --读取下一条数据 While @@Fetch_Status=0 --游标状态正确，则进去循环 Begin Print @Name Fetch Next From Curs Into @Name --读取下一条数据 ... 阅读全文