Precision of data types

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Markus Eßmayr (essmayr/at/racon-linz.at)
Date: 10/08/04 

Date: Fri, 8 Oct 2004 09:37:40 +0200

Hi there,

I have a DataSet, filled using a SELECT command.
What I'd like to know is, what precision is defined for decimal columns.

Example:
CREATE TABLE ...... column1 decimal(10, 2) .......

In my application, I need to know, that this columns has 2 digits behind the
comma.

Is there a way?

Thanks in advance!

Relevant Pages

  • Re: Precision of data types
    ... > What I'd like to know is, what precision is defined for decimal columns. ... > In my application, I need to know, that this columns has 2 digits behind ... > comma. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SqlTypes Decimal
    ... According to the specs for Sql Server 2005, max precision is 38 for the decimal data type, by default, and the default precision is ... to a problem when working with decimal columns. ...
    (microsoft.public.dotnet.framework.adonet)
  • Decimal precision change - MySQL & MS-Access
    ... table on the database (tblTime) with three Decimal columns. ... Access, the precision of the decimal columns keeps setting to, ... which results in a data truncation error. ...
    (microsoft.public.access.modulesdaovba)
  • Decimal precision change - MySQL and MS-Access
    ... table on the database (tblTime) with three Decimal columns. ... Access, the precision of the decimal columns keeps setting to, ... which results in a data truncation error. ...
    (microsoft.public.access.modulesdaovba)