同一表内,各部份行自动重新编号T-SQL处理代码
摘要:
--同一表内,各部份行自动重新编号T-SQL处理代码 select identity(int,1,1) as id,* into # from DS order by Department select Department,min(id) as n,max(id) as m into #DMN from # group by Department update DS set DS... 阅读全文
posted @ 2007-09-30 17:08 Double_ 阅读(395) 评论(0) 推荐(0) 编辑