使用表变量排序

  declare @tbl table(id int identity(1,1),nid int) --定义表变量  
  insert into @tbl(nid) select [id] from sfxm  order by xh asc  
  update sfxm set sfxm.xh=s.[id]  from sfxm,@tbl s where sfxm.[id]=s.nid

转载于:https://www.cnblogs.com/lxydmq/archive/2008/06/10/1216831.html