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 (columnN ame AS XML ). value ( '(/Group1/Title/Name)[1]' , 'nvarchar(100)' ) AS Name ,
dah sama besar dahhhh
ReplyDeleteBUbuye sampai laa ni lebih2 kan Shiro
DeleteAmboiihhh...posing baekk nye...ehehehe..^^
ReplyDeleteahaha
Delete