/*
Exec insert_EdunetBoard
@board_select = 1
, @strID='icdtl'
, @strName='한영민'
, @strMail='icdtl@hotmail.com'
, @strTitle='test'
, @strContent='test'
, @intBoard_number=1
, @intRead_number=1
, @intRef=1
, @intRe_level=1
, @intRe_count=1
*/
/*
작성일 : 표시 없음
수정일 : 2003-07-09
수정한 사람 : 한영민
수정한 내용 : 똑같은 쿼리 분기식에 동일한 쿼리를 TABLE 이름만으로 분기하여 이를 SP_EXECUTESQL로 수정
*/
ALTER PROCEDURE [insert_EdunetBoard]
@board_select int,
@strID Varchar(13),
@strName Varchar(10),
@strMail Varchar(100),
@strTitle Varchar(100),
@strContent nvarchar(4000),
@intBoard_number int,
@intRead_number int,
@intRef int,
@intRe_level int,
@intRe_count int
As
DECLARE @BoardName nvarchar(30), @strSQL nvarchar(1000)
IF @board_select = 1
Set @BoardName = 'Edunet_Board_counsel'
ELSE IF @board_select = 2
Set @BoardName = 'Edunet_Board_notice'
ELSE IF @board_select = 3
Set @BoardName = 'Edunet_Board_event'
ELSE IF @board_select = 4
Set @BoardName = 'Edunet_Board_review'
ELSE IF @board_select = 5
Set @BoardName = 'Edunet_Board_news'
ELSE IF @board_select = 6
Set @BoardName = 'Edunet_Board_cesipan'
ELSE IF @board_select = 7
Set @BoardName = 'Edunet_Board_request'
ELSE
Return 0
SET @strSQL = ' Insert ' + @BoardName + ' ( strName, strID, strMail, strTitle, strContent, intRead_number, intBoard_number, intRef, intRe_level, intRe_count) '
SET @strSQL = @strSQL + ' Values ( ''' + @strName + ''',''' + @strID + ''',''' + @strMail + ''',''' + @strTitle + ''',''' + @strContent + ''',' + Convert(varchar(10), @intRead_number) + ',' + Convert(varchar(10), @intBoard_number) + ',' + Convert(varchar(10), @intRef) + ',' + Convert(varchar(10), @intRe_level) + ',' + Convert(varchar(10), @intRe_count) + ') '
EXECUTE SP_EXECUTESQL @strSQL
CREATE Procedure [insert_EdunetBoard]
@board_select int,
@strID Varchar(13),
@strName Varchar(10),
@strMail Varchar(100),
@strTitle Varchar(100),
@strContent text,
@intBoard_number int,
@intRead_number int,
@intRef int,
@intRe_level int,
@intRe_count int
As
if @board_select = 1
Begin
Insert Edunet_Board_counsel ( strName, strID, strMail, strTitle, strContent, intRead_number, intBoard_number, intRef, intRe_level, intRe_count)
Values ( @strName, @strID, @strMail, @strTitle, @strContent, @intRead_number, @intBoard_number, @intRef, @intRe_level, @intRe_count)
Return 1
End
ELSE IF @board_select = 2
Begin
Insert Edunet_Board_notice ( strName, strID, strMail, strTitle, strContent, intRead_number, intBoard_number, intRef, intRe_level, intRe_count)
Values ( @strName, @strID, @strMail, @strTitle, @strContent, @intRead_number, @intBoard_number, @intRef, @intRe_level, @intRe_count)
Return 1
End
ELSE IF @board_select = 3
Begin
Insert Edunet_Board_event ( strName, strID, strMail, strTitle, strContent, intRead_number, intBoard_number, intRef, intRe_level, intRe_count)
Values ( @strName, @strID, @strMail, @strTitle, @strContent, @intRead_number, @intBoard_number, @intRef, @intRe_level, @intRe_count)
Return 1
End
ELSE IF @board_select = 4
Begin
Insert Edunet_Board_review ( strName, strID, strMail, strTitle, strContent, intRead_number, intBoard_number, intRef, intRe_level, intRe_count)
Values ( @strName, @strID, @strMail, @strTitle, @strContent, @intRead_number, @intBoard_number, @intRef, @intRe_level, @intRe_count)
Return 1
End
ELSE IF @board_select = 5
Begin
Insert Edunet_Board_news ( strName, strID, strMail, strTitle, strContent, intRead_number, intBoard_number, intRef, intRe_level, intRe_count)
Values ( @strName, @strID, @strMail, @strTitle, @strContent, @intRead_number, @intBoard_number, @intRef, @intRe_level, @intRe_count)
Return 1
End
ELSE IF @board_select = 6
Begin
Insert Edunet_Board_cesipan ( strName, strID, strMail, strTitle, strContent, intRead_number, intBoard_number, intRef, intRe_level, intRe_count)
Values ( @strName, @strID, @strMail, @strTitle, @strContent, @intRead_number, @intBoard_number, @intRef, @intRe_level, @intRe_count)
Return 1
End
ELSE IF @board_select = 7
Begin
Insert Edunet_Board_request ( strName, strID, strMail, strTitle, strContent, intRead_number, intBoard_number, intRef, intRe_level, intRe_count)
Values ( @strName, @strID, @strMail, @strTitle, @strContent, @intRead_number, @intBoard_number, @intRef, @intRe_level, @intRe_count)
Return 1
End
Else
Return 0
