I have a VIEW written in Microsoft SQL Server which has some statements like "For XML Path (' ') '... in select statement. I have to migrate this VIEW to MySQL view. In MySQL this statement is throwing error. So my question is what to use in place of For XML??
Here's a line from the actual code-:
Select .......,
Substring (select ';' + Domain.Dom as [text()] from
(Select CD.Domaindescription + '(' + CD.Domaincode + ')' as DOM from Conf_Domain CD
inner join
GDA_User_Profile_Access GUPA on GUPA.Domainid = CD.Domainid and GUPA.Userprofileid = P.Userprofileid
) As Domain For XML Path (' ')),2,1000) as UPDomain,
............
How to modify it to MySQL code??
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…