How to use variables in SQL raiserror

I am trying to show my int variables in raiserror @MaxAmount and @MinAmount

Raiserror('Total Amount should be less than %s and Greater than %s',16,1,@MaxAmount,@MinAmount)

​x
 
Raiserror('Total Amount should be less than %s and Greater than %s',16,1,@MaxAmount,@MinAmount)​

But Im getting error:

Must declare the scalar variable “@MaxAmount”.

Answer

%s is used for varchar and your variable is of type int hence you need to try to use correct format specifier ie, %d

DECLARE @MaxAmount int = 16;
DECLARE @minAmount int = 1;
Raiserror('Total Amount should be less than %d and Greater than %d',@MaxAmount,@MinAmount)

 
DECLARE @MaxAmount int = 16;DECLARE @minAmount int = 1;Raiserror('Total Amount should be less than %d and Greater than %d',@MaxAmount,@MinAmount)​

Check RAISEERROR for details.