반응형
IF…ELSE IF…ELSE
https://simplesqltutorials.com/if-elseif-else/
The IF…ELSE IF….ELSE Statement: Everything You Should Know
The IF...ELSE structure and the IF...ELSE IF...ELSE structure are the most basic SQL Server Decision Structures you should know.
simplesqltutorials.com
IF(<condition is true>)
BEGIN
<execute some code>
END
ELSE IF(<different condition is true>)
BEGIN
<execute some other code>
END
ELSE
BEGIN
<execute some other other code>
END반응형
'프로그래밍 > DataBase' 카테고리의 다른 글
| [MS-SQL] Begin Tran (0) | 2023.07.19 |
|---|---|
| [MSSQL] 랜덤 (무작위) Select (0) | 2023.07.18 |
| [MSSQL] 월의 마지막 날짜 구하기 (0) | 2023.07.03 |
| [MSSQL] 날짜차이, 이전 행 정보 LAG LEAD (0) | 2023.07.03 |
| [MSSQL] identity 를 설정한 칼럼에 insert 하기 (0) | 2023.06.19 |