SQL Server CE 用Select Case 來將欄位NULL值轉為0
SELECT (CASE WHEN PUR_AMT IS NULL THEN 0 ELSE PUR_AMT END) PUR_AMT
FROM PDA_PCOTI
SQL Server CE 用Select Case 來將欄位NULL值轉為0
SELECT (CASE WHEN PUR_AMT IS NULL THEN 0 ELSE PUR_AMT END) PUR_AMT
FROM PDA_PCOTI