select * , id=identity(int,1,1) into tb1 from 视图1
select * , id=identity(int,1,1) into tb2 from 视图2select m.学号,m.成绩,n.名次 from tb1 m , tb2 n where m.id = n.iddrop table tb1,tb2
select * , id=identity(int,1,1) into tb2 from 视图2select m.学号,m.成绩,n.名次 from tb1 m , tb2 n where m.id = n.iddrop table tb1,tb2
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货