[2k] raiserror sp_addmessage formatmessage 처리 예

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...
   */