How to use variables in SQL raiserror
%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)
Check RAISEERROR for details.
You need to use %I for integers and as mentioned, declare the variables before use.
declare @MaxAmount int, @MinAmount int
select @MaxAmount = 50, @MinAmount = 5
Raiserror('Total Amount should be less than %i and Greater than %i',16,1,@MaxAmount,@MinAmount)
I think you try in this way:
DECLARE @MaxAmount int = 16;
DECLARE @MinAmount int = 1;
Raiserror('Total Amount should be less than %d and Greater than %d',@MaxAmount,@MinAmount)
If you want further information about RAISERROR, go here