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 ,
Shiro ni comel la
ReplyDeletetambah2 lg time dia buat mata bulat terkebil2 tu haha
bila tgk gambar dia kecik2 dulu..harap sgt dia tak besar2...hahha..boleh x?hehhehe
ReplyDelete