Posted by Boot2TheHead on 12/08/06 17:34

This one cost me a solid half hour yesterday. I'm wondering why on
earth the default precision for a decimal type is 18,0. Maybe I'm
mistaken. A decimal datatype sort of implies that you'd want something
after the decimal!

Question is, can I set this database-wide? Like all new decimal
datatypes have a precision of 12,6 or something like that? I haven't
seen anything about this in the googling I have done...

• Next in forum: memory 64bit windows , 32 bit Sql
• Prev in forum: PRINT debug messages and CURSOR in stored procedure confuses DTS; "Invalid Pointer"
• Thread view: set default precision on decimal type?

[Reply to this message]