MS-SQL 서버는 프로시져 네이밍 규칙이 다음과 같다.
  기존예시 : MARIA =>PKG_SYS$GET_FAVORITY
            ORACLE=>PKG_SYS.GET_FAVORITY
    MSSQL(소문자) => pkg_sys_get_favority
    
    MS-SQL SERVER DBHelper에서는 '$', '.' => '_' 로 변환되어 호출한다.
  
  
     <조회용 프로시져>
ALTER   PROCEDURE [dbo].[pkg_sys_get_favorite]
    @A_PLANT NVARCHAR(10),
    @A_LANG NVARCHAR(10),
    @A_USER_ID BIGINT,
    @N_RETURN INT OUTPUT,
    @V_RETURN NVARCHAR(4000) OUTPUT
AS
BEGIN
    SET NOCOUNT ON;
    DECLARE @li_seq NVARCHAR(3);
          
    BEGIN TRY	 
          
	select A.MENU_ID MENUSEQ,
		A.MENU_ID,
		C.CODE FORM,
		C.CODE,
		C.NAME,
		C.A_ADD,
		C.A_DELETE ,
		C.A_SAVE ,
		C.A_PRINT ,
		B.PATH ,
		A.DISP_SN
	from SYS_FAVORITE A
	inner join SYS_MENU B on A.MENU_ID = B.MENU_ID
	inner join SYS_PROG C on C.PROG_ID = B.PROG_ID 
	where A.USER_ID = @A_USER_ID
		and A.DELETE_YN = 'N'
		and C.USE_YN = 'Y'
	order by A.DISP_SN;
    	
	SET @N_RETURN = 0;
    SET @V_RETURN = '저장되었습니다.';
   
          
    END TRY
    BEGIN CATCH
	SET @N_RETURN = -1;
	SET @V_RETURN = ERROR_MESSAGE();
    END CATCH
END;