基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

left join

use TestDB
go
select Id,FName,LName,Cid from Table_1
select Id,FName,LName,Cid from Table_2

select a.* from Table_1 as a
left join Table_2 as b on a.Id=b.Id
where b.FName is null

select a.* from Table_1 as a
where a.Id not in(select Id from Table_2)

select a.*,b.* from Table_1 as a
right join Table_2 as b on a.Id=b.Id
where a.FName is not null

select a.* from Table_1 as a
union select b.* from Table_2 as b

if exists(select 1 from sysobjects where id=OBJECT_ID('add3') and objectproperty(id, 'IsInlineFunction ')=0)
begin
drop function add3
end


create function add3(@a int,@b int,@c int)
returns int
as
begin
return @a @b @c
end

select add3(3,4,5)