34,593
社区成员
发帖
与我相关
我的任务
分享
不需要带参数存储过程与sql语句也没有什么区别呀,
create procedure GetDataList
as
begin
select b.ServiceTag a.email from a left join b on b.ServiceTag like '%' + a.ServiceTag a.email + '%'
end
select b.ServiceTag,a.email
from b
left join a on charindex(','+a.ServiceTag+',',b.ServiceTag)>0
declare @ta table(ServiceTag varchar(16),email varchar(20))
insert @ta select '3HTHY1X','wjeo@ooi.com'
insert @ta select 'GPXHY1X','ghf@on.com'
insert @ta select '18THY1X','ini@jo.com'
declare @tb table(ServiceTag varchar(100),email varchar(400))
insert @tb select '2HTHY1X,3HTHY1X',null
insert @tb select 'GPXHY1X,HPXHY1X,JPXHY1X',null
insert @tb select 'G7THY1X,H7THY1X,J7THY1X,18THY1X,28THY1X',null
update b
set email = a.email
from @tb b
left join @ta a on charindex(','+a.ServiceTag+',',','+b.ServiceTag+',')> 0
select * from @tb
/*
ServiceTag email
---------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2HTHY1X,3HTHY1X wjeo@ooi.com
GPXHY1X,HPXHY1X,JPXHY1X ghf@on.com
G7THY1X,H7THY1X,J7THY1X,18THY1X,28THY1X ini@jo.com
*/