반응형
  1. /**********************************************************************************************
    -- Title : [2k] raiserror sp_addmessage formatmessage 처리 예
    -- Reference : dBRang.com
    -- Key word : sp_addmessage, formatmessage, raiserror
    **********************************************************************************************/

    EXEC sp_addmessage 50001,10, 'Hello World, from : %s, process id: %#6x', @lang='English', @replace='REPLACE'

    DECLARE @parm1 varchar(30), @parm2 int
    SELECT @parm1 = USER_NAME(), @parm2 = @@spid
    RAISERROR (50001, 15, -1, @parm1, @parm2)
    /*
    서버: 메시지 50001, 수준 15, 상태 1, 줄 3
    Hello World, from : dbo, process id:   0x38
    */
     

    DECLARE @parm1 varchar(30), @parm2 int, @message varchar(100)
    SELECT @parm1=USER_NAME(), @parm2=@@spid
    SELECT @message = FORMATMESSAGE(50001, @parm1, @parm2)
    PRINT 'The message is: ' + @message
    /*
    The message is: Hello World, from : dbo, process id:   0x38
    */
     

    DECLARE @errmsg varchar(100), @dbname sysname

    SET @dbname = db_name()
    SET @errmsg = 'There is no ''%s'' Database in this SQL Server...'  

    RAISERROR(@errmsg, 16,1, @dbname)
    /*
    메시지 50000, 수준 16, 상태 1, 줄 8
    There is no 'tempdb' Database in this SQL Server...
    */
반응형

+ Recent posts