--没有主键:
select row_number=identity(int,1,1), * into #temp from 表--有主键:
select row_number=(select count(1) from 表 where 主键<=a.主键), * from 表 AS a
select row_number=identity(int,1,1), * into #temp from 表--有主键:
select row_number=(select count(1) from 表 where 主键<=a.主键), * from 表 AS a
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货