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 ,
yeahh cat rules!! ^_^
ReplyDeletemeowmanis: cuaca last weeken kan ujan + sejuk..mmg syiok derang berhibernasi..hehe..aman umah kejap
ReplyDeleteish2..kumpul lemak belaka
ReplyDeletecomeynye dorang tido.... :D
ReplyDelete