Why does an integer datatype variable accept a string value in a stored procedure in SQL Server? How to solve it?
why an int datatype variable accept a string format value in stored procedure in SQL Server.
Ask by Ravi Vishwakarma
Updated 13 Oct 2021
Passing a number in string format to an integer variable in a stored procedure :
When pass a value to integer datatype variable in the form of string value then that accept it because after accept first that value is implicitly CAST to an integer then the value is assigning to the parameter.
Ex- If we pass an integer value as ' 145 ' to integer type parameter then it implicitly CAST to an integer type value successfully in 145 then it assigned to the parameter of stored procedure then the statement is work file.
I have create a Stored Procedure with two parameters,
We pass Value to parameter of above stored procedure like-
The above procedure work file.
If we pass the value ' 145' instead of 145 to @ID parameter and ' Radhe Krishna ' to @Name parameter then also that procedure execute fine because before accepting the value to parameter that value will CAST first to the parameters datatype then assign to the parameters so stored procedure work fine and execute.
Note - CAST is function to convert one datatype value in other datatype value. CONVERT() is also used for same purpose.