Home Forums Testing Center Question of the Day (QOD) Question of the Day for 01 Dec 2005 RE: Question of the Day for 01 Dec 2005
SQLBill
SSC Guru
Points: 51440
More actions
December 1, 2005 at 7:56 am
#607061
While it was correct, the answer wasn't complete. Per BOL, VARCHAR defaults to 1 when it's used in a data definition or variable declaration statement. BUT it defaults to 30 when used with CAST.
-SQLBill