David Conn (2/1/2012)
It was a good question but you shouldn't have to know these arcane default values
Personally my opinion is that you shouldn't have to know the defaults because you never ever declare varchar/char/nvarchar/nchar/binary/varbinary/etc without specifying a length.
I would personally like to see declaring one of those data types without specifying a length deprecated. Won't happen though.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability