USP_TURBOPARSE_UPDATEDICTIONARY

Parameters

Parameter	Parameter Type	Mode
@FILECODE	int	IN
@DICTIONARYFILE	varbinary	IN
@UPDATEDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_TURBOPARSE_UPDATEDICTIONARY (
                @FILECODE int,
                @DICTIONARYFILE varbinary(max),
        @UPDATEDATE datetime
            ) as begin
                set nocount on;

        set @UPDATEDATE = coalesce(@UPDATEDATE, getdate());

                if (exists(select 1 from dbo.TURBOPARSEDICTIONARY where FILECODE = @FILECODE))
          update dbo.TURBOPARSEDICTIONARY
          set DICTIONARYFILE = @DICTIONARYFILE,
              UPDATEDATE = @UPDATEDATE
          where FILECODE = @FILECODE;
        else
                    insert into dbo.TURBOPARSEDICTIONARY
                        (FILECODE, DICTIONARYFILE, UPDATEDATE)
                    values
                        (@FILECODE,@DICTIONARYFILE,@UPDATEDATE);

                return 0;
            end;