아래 문장을 오라클 프로시저로 변환할려고 해요..도와주세요....
CREATE PROC GetBoardList @b_id varchar(12), @search_option varchar(10), @search_key varchar(30), @topcount varchar(12) AS DECLARE @strSQL varchar(512) --검색 정보가 없는경우 IF (@search_key = '') SET @strSQL = 'SELECT TOP' + @topcount + '* FROM boardlist' + 'WHERE b_id = ' + Char(39) + @b_id + Char(39) + 'ORDER BY c_id DESC,c_step ASC' --'제목'이나 '작성자'로 검색하는 경우 ELSE IF (@search_option = 'subject' OR @search_option ='writer') SET @strSQL = 'SELECT TOP '+@topcount + '*FROM boardlist' + 'WHERE b_id = '+Char(39)+@b_id +Char(39)+'%'+ @search_key +'%'+Char(39)+ 'ORDER BY c_id DESC,c_step ASC'
EXEC (@strSQL) GO 좋은하루되세요..^--^.... |