SELECT BussinessNo = STUFF(
REPLACE(
REPLACE(
(
SELECT N.business_no FROM T_delegate_list N
WHERE N.g_mode = 'LR077639'
FOR XML AUTO),
'<N business_no="', '|'),'"/>','')
,1,1,'')
SQL 列提取组成字符串
くろさきいちご
SELECT BussinessNo = STUFF(
REPLACE(
REPLACE(
(
SELECT N.business_no FROM T_delegate_list N
WHERE N.g_mode = 'LR077639'
FOR XML AUTO),
'<N business_no="', '|'),'"/>','')
,1,1,'')