i'v try on sql server 2000,it run data type numeric(18,6) --- On Mon, 6/14/10, johan max <johans...@yahoo.com> wrote:
From: johan max <johans...@yahoo.com> Subject: [programmer-vb] SQL Server 2000 ketelitian To: programmer-vb@yahoogroups.com Date: Monday, June 14, 2010, 11:22 AM Greetings, I got problem with my SQL Server 2008 database. The problem is i need a precision 6 digit (at least) example 0.123456. I have use numeric dataytpe (28,9). But it cannot work. The company which i work doesn't accept the fact that SQL server doesn't support that level precision. The option are : 1. i change to other database. The question is which database ? 2. use other data type. Float is not accepted. Any suggestion accepted..