Owh harini pagi2 mengadap sql. Patu cecepat breakfast. And then discussion with pmw team. Baru nak bernafas, concall dgn PLMS. Settle yang tu, kejar Man pulak. Tengah kejar buka PMW. Tau2 dh lunch. Makan sat.. And sambung ngadap sql.
How to convert xml into column
My case, the data is in string. So i need to convert into xml first
Today's top syntax.
Cast (column name as XML)
SELECT id,
Cast(columnName AS XML).value('(/Group1/Title/Name)[1]', 'nvarchar(100)') AS Name,
Comments
Post a Comment