Assalamualaikum semua. Hari ni mama bubuye nk bercerita pasal anak manja mama bubuye. Sapa lagi kalo bukan si Shiro.
Shiro ni judges pernah gelar dia 'mr grumpy'. Haha. As usual, dia ni behave masa awal2 je.asal lepas lunch, dari hensem boy jadi mr grumpy. Alhamdulillah kali ni ring 1st Shiro dpt no 1. The next ring, pas lunch. Haaa..even tak dpt no besh 2, shiro dpt no 6 and 7. Masa ni mmg dia stress. Susah judge nk buat keje. Apa2 pun, Alhamdulillah dpt juga bawa balik rosettes.
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 ,
tahniah Mama Bubuye & Shiro the Hero ofkos
ReplyDeletecongrate shirooo~~~ heeeee
ReplyDeletetahniah yuolssssssssss..!!! hehehe
ReplyDelete