SQL Raiserr

Raiserr

-- Be sure instlang.sql has been run to install Deutsch as a language

EXEC sp_addmessage 50001, 10, 'Hello World', @replace='REPLACE'
-- New message 50001 for U.S. English
EXEC sp_addmessage 50001, 10, 'Hallo Welt' , @lang='Deutsch',
    @replace='REPLACE' 
-- New message 50001 for German
GO
RAISERROR (50001,15,1)
GO
SET LANGUAGE Deutsch
GO
RAISERROR (50001,15,1)
GO
SET LANGUAGE us_english
GO
EXEC sp_addmessage 50001, 10,
    'Hello World, from: %s, process id: %#6x', @replace='REPLACE'


DECLARE @parm1 varchar(30), @parm2 int
SELECT @parm1=USER_NAME(), @parm2=@@spid
RAISERROR (50001, 15, -1, @parm1, @parm2)

SETUSER 'kalend'
go


DECLARE @parm1 varchar(30), @parm2 int
SELECT @parm1=USER_NAME(), @parm2=@@spid
RAISERROR (50001, 15, -1, @parm1, @parm2)
GO

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
GO