Implicit conversion between data types
This is what you need to remember about implicit conversion:
- For comparing two values in SQL Server, they need to have the same data type.
- If the data types are different, SQL Server implicitly converts one type to another, based on data type precedence.
- The data type with the lower precedence is converted to the data type with the higher precedence.
In this exercise, you are going to test if explicit conversion works between a numeric type and a character. use information from the conversion table, where the implicit and explicit conversions between all data types are presented. You are going to try an implicit conversion between two different data types.
For this, you will use the voters table and will compare the total_votes numeric column with a character.
Este exercício faz parte do curso
Functions for Manipulating Data in SQL Server
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
SELECT
first_name,
last_name,
total_votes
FROM voters
___