27,580
社区成员
发帖
与我相关
我的任务
分享
create table #t(x varchar(100))
insert into #t(x)
select 'Veeva CRM@Sync Issue@登陆失败@30@' union all
select 'EDW@Data Query and Confirm@检查用户没有岗位的原因@20@' union all
select 'ICAN@Data Query and Confirm@用户咨询@10@ICAN'
select x=reverse(substring(reverse(x),
charindex('@',reverse(x))+1,
charindex('@',reverse(x),charindex('@',reverse(x))+1)-charindex('@',reverse(x))-1))
from #t
/*
x
---------------------
30
20
10
(3 行受影响)
*/