Question

Class SQL performs automatically; discuss at least two risks inherent in letting SQL Server to perform conversion. In your opinion what is the best approach for insuring that any data type conversion will work all the time as expected? Provide a vivid example to summarize your written detail explanation.

Answer 1

Sql server supports two types of data type conversion : implicit amd explicit.

Implicit means that the database engine will convert the data type automatically , a process invisible to the user. Explicit means that you must specify how the data type should be converted. If you don't specify how sql sever should convert the datatype to do what you want(explicitly), it will try to guess your intentions (implicitly).

In my opinion explicit is the best approach for any data type conversion.

For example, when we multiply decimal datatype with an integer ,the data undergoes internal transformation and implicitly converts an integer to decimal data type and the result is of decimal datatype.