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)
But Im getting error:
Must declare the scalar variable “@MaxAmount”.
Advertisement
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)
Check RAISEERROR for details.