Posted by Erland Sommarskog on 12/08/06 23:11

Roy Harvey (roy_harvey@snet.net) writes:
> I wouldn't expect that to be something that can be configured. As to
> the default of (18,0) vs some other value, I would never allow a
> default to be used so it doesn't strike me as a problem. It is so
> much safer, and so simple, to always specify what you need explicitly
> that I just can't get interested in the issue.

Yes, I entirely agree. If only Sybase and/or Microsoft had agreed.
The defaults of decimal and the character data types are do no help
to the users, but a common source of error.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Searching for Last DateTime
• Prev in forum: Re: set default precision on decimal type?
• Thread view: Re: set default precision on decimal type?

[Reply to this message]