You try to add a last name to a field defined as an integer. What happens?

You try to add a last name to a field defined as an integer. What happens?

You try to add a last name to a field defined as an integer. What happens?


B – SQL Server rejects the operation and declares an error.
C – SQL Server accepts the value because you originally defined the data type as sql_variant.

(You maintain data integrity by stipulating to SQL Server how it should treat data. SqlVariant is a catchall data type, used when you don’t know which type of data needs to be inserted.)