create table cp(Number smallint )
declare @i int
select @i=1
while (@i<=35)
begin
insert into cp select @i
select @i=@i+1
end
select * from cp
--可以相同
select * from cp t1,cp t2,cp t3,cp t4,cp t5,cp t6,cp t7
--不同
select count(*) from cp t1,cp t2,cp t3,cp t4,cp t5,cp t6,cp t7
where t1.Number<>t2.Number
and t1.Number<>t2.Number
and t1.Number<>t3.Number
and t1.Number<>t4.Number
and t1.Number<>t5.Number
and t1.Number<>t6.Number
and t1.Number<>t7.Number
and t2.Number<>t3.Number
and t2.Number<>t4.Number
and t2.Number<>t5.Number
and t2.Number<>t6.Number
and t2.Number<>t7.Number
and t3.Number<>t4.Number
and t3.Number<>t5.Number
and t3.Number<>t6.Number
and t3.Number<>t7.Number
and t4.Number<>t5.Number
and t4.Number<>t6.Number
and t4.Number<>t7.Number
and t5.Number<>t6.Number
and t5.Number<>t7.Number
and t6.Number<>t7.Number
declare @i int
select @i=1
while (@i<=35)
begin
insert into cp select @i
select @i=@i+1
end
select * from cp
--可以相同
select * from cp t1,cp t2,cp t3,cp t4,cp t5,cp t6,cp t7
--不同
select count(*) from cp t1,cp t2,cp t3,cp t4,cp t5,cp t6,cp t7
where t1.Number<>t2.Number
and t1.Number<>t2.Number
and t1.Number<>t3.Number
and t1.Number<>t4.Number
and t1.Number<>t5.Number
and t1.Number<>t6.Number
and t1.Number<>t7.Number
and t2.Number<>t3.Number
and t2.Number<>t4.Number
and t2.Number<>t5.Number
and t2.Number<>t6.Number
and t2.Number<>t7.Number
and t3.Number<>t4.Number
and t3.Number<>t5.Number
and t3.Number<>t6.Number
and t3.Number<>t7.Number
and t4.Number<>t5.Number
and t4.Number<>t6.Number
and t4.Number<>t7.Number
and t5.Number<>t6.Number
and t5.Number<>t7.Number
and t6.Number<>t7.Number
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货