Table▶ 파일업로드&다운로드 게시판_MSSQL

▶ MSSQL_ 테이블 만들기
create table FileBoard
(
idx int PRIMARY KEY,--고유번호
deldate char(10) not null unique,--발송일자
hakdoc varchar(25) DEFAULT 'X',--학문서
hakmail varchar(20) DEFAULT 'X',--학메일
dondoc varchar(25) DEFAULT 'X',--돈문서
donmail varchar(20) DEFAULT 'X',--돈메일
regdate smalldatetime DEFAULT(GETDATE())--등록일자
)

▶ Procedure insert
alter proc doubleoInsert(@deldate char(10))
as
begin
 begin try  
  insert into doubleo_board (idx, deldate) values(doubleo.FUNC_doubleo_board(),@deldate)
  select(0)
 end try

 begin catch
  select(1)
 end catch
end

▶ Procedure List
alter proc doubleoList
as
begin
select idx,deldate, hakdoc,hakmail,dondoc,donmail,regdate from doubleo_board order by deldate desc
end

▶ BasicUpdate create proc updateboard ( @idx int, @type int, @filename varchar(25) ) as begin  if(@type = 1)  begin  update doubleo_board set hakdoc = @filename  where idx = @idx  end  else if(@type = 2)  begin   update doubleo_board set hakmail = @filename   where idx = @idx  end  else if(@type = 3)  begin   update doubleo_board set dondoc = @filename   where idx = @idx  end  else  begin   update doubleo_board set donmail = @filename   where idx = @idx  end end

▶ DynamicUpdate alter proc doubleoUpdate ( @idx int, @upType varchar(10), @filename varchar(25) ) as begin  declare @sql varchar(100)  set @sql= N'update doubleo_board set '+@upType+'='''+@filename+''' where idx='+cast(@idx as varchar)+''  execute (@sql)  --print(@sql) end