mssql @@ERROR=0 이란?

“시스템함수”

@@ERROR=0 오류없음

@@ERROR=0 오류없음

@@ERROR=0 오류없음

예문)

if @error = 0 or @error IS NULL
begin
SELECT ‘성공’ AS result, null AS message, null as error_code
COMMIT TRAN
end
else if @error <> 0
begin
SELECT ‘실패’ AS result,‘성적처리 에러’ AS message, ‘01’ AS error_code
–트랜잭션을 rollback
ROLLBACK TRAN
end