What are implicit conversions and why you should care

from blog Just Some Code, | ↗ original
SQL Server compares columns and parameters with the same data types. But, if the two data types are different, weird things happen. Let’s see what implicit conversions are and why we should care. An implicit conversion happens when the data types of columns and parameters in comparisons are different. And SQL Server has to convert between them,...