Adrian Hills • 4/6/2010

SQL CAST to VARCHAR without size

This technical article details a common SQL Server pitfall: using CAST or CONVERT to VARCHAR without specifying a length. It explains that the default length is 30, which can cause arithmetic overflow errors with large numbers, and that declaring a VARCHAR variable without a length defaults to 1, leading to silent truncation. The post serves as a warning and best practice guide for developers.

0 comments

#data types #SQL Server #Data Conversion