一下3个Sql语句哪一个效率最高?create table #Relation (ID int)
insert into #Relation values(1)
insert into #Relation values(2)
insert into #Relation values(3)select * from MyTable inner join #Relation on MyTable.ID=#Relation.ID
select * from MyTable where ID in (1,2,3)
select * from MyTable where (select top 1 1 from #Relation where #Relation.ID=MyTable.ID)=1
insert into #Relation values(1)
insert into #Relation values(2)
insert into #Relation values(3)select * from MyTable inner join #Relation on MyTable.ID=#Relation.ID
select * from MyTable where ID in (1,2,3)
select * from MyTable where (select top 1 1 from #Relation where #Relation.ID=MyTable.ID)=1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货