select IDENTITY(int,1,1) as NameID,* into #t from MissionAssignView
select * from #t order by NameID
drop table #t
转载于:https://www.cnblogs.com/jhtchina/archive/2005/03/09/115532.html
select IDENTITY(int,1,1) as NameID,* into #t from MissionAssignView
select * from #t order by NameID
drop table #t
转载于:https://www.cnblogs.com/jhtchina/archive/2005/03/09/115532.html