Skip to main content

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(columnName AS XML).value('(/Group1/Title/Name)[1]', 'nvarchar(100)') AS Name,



Comments

Post a Comment

Popular posts from this blog

2021 post

 Hello all, How are you? I hope you are doing well. Yes, tak sangka we have been fighting with Covid-19 dah setahun kan. A lot of things has been changed. People now started to adopt working from home. I even have been doing this even b4 Covid-19, i feel the difference because before this, i can work from coffee house, sunway lagoon(eh), anywhere je. but now, kena Stay At Home ok. Fews things that i tak puas hati 1- why Teams kenot buat call mcm skype 2- why hp Huawei baru tak leh nk install a lot of Google application(Teams pun tak lepas wei..hadoi) 3- What can i do to improve my skill. Now i started doing Talend. I still feel byk nya benda yg i tak tau.. Best explore benda ni..haha
Post a Comment
Read more

My Struggle

I started my 1st day MCO 3.0 with a broken laptop. Merajuk maybe. It happens when i tried to register for Astra Zeneca Vaccination. At first, i used my Huawei Nova 3i to access the vaccinecovid website. Adek & Rudy also at the living hall together try to get the slot. Both of them successfully get a slot but me? eventho i am the 1st to get thru to the registration page, i couldnt get any slot at all. Tried until 12.30pm. i started to feel the stress. Nak nangis oi. Sampai adik try her very best to help me pun tak dapat. End up i try using my laptop. Chorome is not helping at all. Keep displaying error message after i struggled to tell the system that i am a human(damn..why do i need to proof myself to a computer?) Imagine the difficulties that i have to go thru just to be able to click the submit button and ends up error, or no slot avail..s**t ..haishh.. Edge pula keep saying slot full.. And the next day, laptop hanged..kaput,,work using my phone to get the approval letter to go t...
Post a Comment
Read more