[mssql] ISNULL

null 값을 치환할 때 사용된다.

 

WITH tmpTable AS 
(
    SELECT 'OIKAWA' AS ename, 9000 AS salary, NULL AS retire UNION ALL
    SELECT 'KUROO' AS ename, NULL AS salary,  'Y' AS retire    
)

SELECT ename
     , salary
     , ISNULL(salary, 0) AS sal -- 숫자 치환
     -- ,ISNULL(salary, 'N') AS sal -- 문자 치환
  FROM tmpTable

 

 

 

https://gent.tistory.com/373

[MSSQL] ISNULL 함수 사용법 (NVL, NVL2, IFNULL)