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 ,
haloh haloh haloh.. ni sume masa kecik ! COMEI !!
ReplyDeletedah besar2 sume ye..
kecik2 semuanya muka suci2 lagi...hehe
Deleteatotototooo omel omel sungguh!
ReplyDeletekecik2 semua omey2 kan??dh besar???uwaaa..muke tak boleh blah...
Delete