Skip to main content

Posts

Showing posts from December, 2019

Cerita Kerja #1

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 ,

Fahryan's adventure #1

It has been a long time since I updated this blog. Dunno why i have an issue to publish the posts. Today let me check if i am able to post this moment when fahryan invaded my territory