補課：請寫出下列每個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
浙公網安備 33010602011771號