SQL 列提取组成字符串时间:2023-03-08 15:10:30 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,'')