Data Conversion in SQL Server
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Wed, 12 Jan 2011 07:00:00 UT
Indexed on
2011/01/12
7:56 UTC
Read the original article
Hit count: 184
Filed under:
Most of the time, you do not have to worry about implicit conversion in SQL expressions, or when assigning a value to a column. Just occasionally, though, you'll find that data gets truncated, queries run slowly, or comparisons just seem plain wrong. Robert Sheldon explains why you sometimes need to be very careful if you mix data types when manipulating values.
Free trial of SQL Backup™
“SQL Backup was able to cut down my backup time
significantly AND achieved a 90% compression at
the same time!” Joe Cheng. Download a free trial now.
“SQL Backup was able to cut down my backup time
significantly AND achieved a 90% compression at
the same time!” Joe Cheng. Download a free trial now.
© SQL Server Central or respective owner
