补课:请写出下列每个SQL语句的显示结果集或记录集行数
不要用查询分析器,绝对考察基础
/*创建表*/
declare @A TABLE(
A_id int not null,
A_strValue varchar(100)
)
declare @B TABLE(
B_id int not null,
B_strValue varchar(100)
)
/*写值*/
insert into @A
select 1,'A' union all
select 2,'AB' union all
select 2,'ABC'
insert into @B
select 1,'A' union all
select 1,'AB' union all
select 2,'ABC'
/*请写出下列每个SQL语句的显示结果集 或 记录集行数*/
1、select a.*,b.* from @A a ,@B b
2、select a.*,b.* from @A a inner join @B b on a.a_id=b.b_id
3、select a.*,b.* from @A a left join @B b on a.a_id=b.b_id
4、select a.*,b.* from @A a right join @B b on a.a_id=b.b_id
5、select a.*,b.* from @A a FULL join @B b on a.a_id=b.b_id
6、select a.*,b.* from @A a CROSS join @B b
7、select a.*,b.* from @A a inner join @B b on a.a_id=2
8、select a.*,b.* from @A a left join @B b on a.a_id=2
9、select a.*,b.* from @A a right join @B b on a.a_id=2
10、select a.*,b.* from @A a FULL join @B b on a.a_id=2
11、select a.*,b.* from @A a CROSS join @B b where a.a_id=2
declare @A TABLE(
A_id int not null,
A_strValue varchar(100)
)
declare @B TABLE(
B_id int not null,
B_strValue varchar(100)
)
/*写值*/
insert into @A
select 1,'A' union all
select 2,'AB' union all
select 2,'ABC'
insert into @B
select 1,'A' union all
select 1,'AB' union all
select 2,'ABC'
/*请写出下列每个SQL语句的显示结果集 或 记录集行数*/
1、select a.*,b.* from @A a ,@B b
2、select a.*,b.* from @A a inner join @B b on a.a_id=b.b_id
3、select a.*,b.* from @A a left join @B b on a.a_id=b.b_id
4、select a.*,b.* from @A a right join @B b on a.a_id=b.b_id
5、select a.*,b.* from @A a FULL join @B b on a.a_id=b.b_id
6、select a.*,b.* from @A a CROSS join @B b
7、select a.*,b.* from @A a inner join @B b on a.a_id=2
8、select a.*,b.* from @A a left join @B b on a.a_id=2
9、select a.*,b.* from @A a right join @B b on a.a_id=2
10、select a.*,b.* from @A a FULL join @B b on a.a_id=2
11、select a.*,b.* from @A a CROSS join @B b where a.a_id=2