오라클과 MSSQL 함수 차이 1

오라클에서 MSSQL 로 디비 작업을 변경해야하는 일이 생겼다..
일단.. 찾아놓은 함수부터 쓱쓱~~ 

#################################################################
DECODE(if 문???)
#################################################################
ORACLE : DECODE( 칼럼, 값 , 참일때, 거짓일때)
SELECT  DECODE(SEX,0,'남성', 1,'여성') AS SEX  FROM 테이블명

MSSQL : CASE WHEN 조건문 then 참일때 ELSE 거짓일때
SELECT CASE WHEN SEX = 0 THEN '남성' ELSE '여성' END AS SEX FROM 테이블명

추가 설명 :
CASE문
      : 정의 : 비교, 조건
      : 문장 :  CASE WHEN  조건문 THEN 결과
                            WHEN 조건문 THEN 결과
                            ELSE 결과
                   END

#################################################################
NVL
#################################################################
ORACLE : NVL( 칼럼, 값)
SELECT NVL(EMAIL,'3333') FROM WCM_USER

MSSQL : isnull(값 , 칼럼)
select isnull('33333333', email) as kakaka from wcm_user

#################################################################
프로시져 실행
#################################################################
ORACLE : BEGIN session_log_prc

MSSQL  : exec rec_call 7

[출처] 오라클과 MSSQL 함수 차이..|작성자 hulint