Dealing With RAISERROR

• abmore

  Hall of Fame

  Points: 3628

  More actions

  December 3, 2007 at 3:13 am

  #63124

  Hi All,

  In SQL for error handling we use RAISERROR function.

  we can also raise the custom Error Like

  DECALRE @strErroMsg VARCHAR(100)

  SET @strErroMsg = = 'Test Error '

  RAISERROR( '%s master not found.', 16, 1, @strErroMsg )

  I tried to use "%d" instead of "%s", also tried to put "%s %s" for passing 2 parameters. but its throwing an Error.

  Can anyone explain me why i can't use any other character ?

• allen davidson

  SSCertifiable

  Points: 7042

  More actions

  December 3, 2007 at 3:56 am

  #756397

  Hi

  typo in your code I think

  DECLARE @strErroMsg VARCHAR(100)

  SET @strErroMsg = 'Test Error '

  RAISERROR( '%s master not found.', 16, 1, @strErroMsg )

  Allen