34,576
社区成员
发帖
与我相关
我的任务
分享
@stringvalue=' leave %leave_Code% %staff_No% ABC'
'''leave'' + @leave_code + @staff_no + ''ABC'''
declare @stringvalue varchar(100)
declare @xml xml
set @stringvalue=' leave %leave_Code% %staff_No% ABC'
select @xml='<n>'+replace(ltrim(replace(@stringvalue,' ',' ')),' ','</n><n>')+'</n>'
;with cte as
(
select c=case when charindex('%',c1.value('.','varchar(30)'))>0 then '@'+replace(c1.value('.','varchar(30)'),'%','') else ''''''+c1.value('.','varchar(30)')+'''''' end from @xml.nodes('/n') as t(c1)
)
select ''''+stuff((select '+'+c from cte for xml path('')),1,1,'')+''''
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
'''leave''+@leave_Code+@staff_No+''ABC'''
(1 行受影响)