IT/JAVA
mybatis if begin 대체
하루콩콩
2023. 1. 17. 10:35
반응형
MSSQL :
if @test_code ='01'
BEGIN
SELECT '1'
END
ELSE
BEGIN
SELECT '2'
END
MYBATIS:
<choose>
<when test = "test_code== 01">
SELECT '1'
</when>
<otherwise>
SELECT '2'
</otherwise>
</choose>
반응형