Why don't I see an implicit conversion in query plan?
I was looking through a stored procedure that one of our developers was using and I noticed he was passing a VARCHAR() value to a user defined function expecting an INTEGER. I looked at the query plan on this and expected to see an implicit conversion somewhere. Am I missing it? Is done behind the scenes? The value is clearly used as an integer. i.e. the user is passing @val1 to the UDF. @val1 is defined as DECLARE @VAL1 VARCHAR(50) = '1234'. Inside the UDF @val1 is used in a math computation.