[MSSQL] UPDATE문 사용하기

728x90

--데이터 수정 (UPDATE data)

UPDATE tblTEST SET [COLUMN NAME1] = '[VALUE]', [COLUMN NAME2] = '[VALUE]' WHERE [CONDITION]

Example)

UPDATE tblTEST SET firstColumn = 'UPTEST', thirdColumn = 'UPTESTUP' WHERE seq = '7'

Result)

Example)

UPDATE tblTEST SET firstColumn = 'UPTEST2', thirdColumn = 'UPTESTUP2' WHERE seq in ('5','7')

Result)

Example)

UPDATE tblTEST SET firstColumn = 'UPTEST3', thirdColumn = 'UPTESTUP3' WHERE seq < '5'

Result)

ITsuIT