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 ,
hehe...leh geng ngan ibuBulat si hantu durian
ReplyDeleteRoxy minah mat saleh pun mkn durian..hehe
ReplyDeletemeowmania: dulu masa bg durian kg tak nak..bila rina buat bubur, dia siap nk rina cecah dgn roti. last 2 week, beli d24, ha..tak cukup2 dia. riso sakit perut..so bg yg kita dh makan..mmmg tinggalkan isi sikit2 utk dia jilat...
ReplyDeleteNoz: tuh laa pasal...dia durian kg xmo..kene d24 baru nak..hampeh kan??
hmmm..BABY pon suke makan durian jugak.. =)
ReplyDelete