set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
/----------------------------------------------------------------------------------------------
1.Stored Procedure : [up_tblboard]
2.관련 Table : tblboard
3.내용 : 글 쓰기 처리 저장 프로시져
4.작성자 : 투이아빠
5.작성일 : 2009.03.19
-----------------------------------------------------------------------------------------------/
ALTER PROCEDURE [dbo].[up_tblboard]
@idx INT --글번호
,@name VARCHAR(50)
,@password VARCHAR(50)
,@email VARCHAR(50)
,@title VARCHAR(50)
,@contents TEXT
,@readcount INT --카운트
,@WebPath VARCHAR(200) --파일
AS
SET NOCOUNT ON
DECLARE @error INT --에러선언
– 격리 수준을 최소로 설정
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
BEGIN TRAN
INSERT tblboard(
idx, name, pass, email, title, contents, readcount, filename
)VALUES(
@idx, @name, @password, @email, @title, @contents, @readcount, @WebPath
)
SELECT @error = @error + @@ERROR
–시스템 함수 @@error를 써서 에러 처리를 해주는 부분
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
SET NOCOUNT OFF
– 격리 수준을 원상 복구
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
