Re: SqlTypes Decimal
- From: "Dave Sexton" <dave@jwa[remove.this]online.com>
- Date: Sat, 19 Aug 2006 13:06:05 -0400
Hi Carlos,
According to the specs for Sql Server 2005, max precision is 38 for the decimal data type, by default, and the default precision is
18. You can examine the global @@MAX_PRECISION variable to retrieve the current maximum value for your database.
If you need to discover the precision for a specific column at runtime, you can execute a query that examines
INFORMATION_SCHEMA.COLUMNS:
USE TheDatabase;
GO
SELECT
NUMERIC_PRECISION,
NUMERIC_SCALE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'aspnet_WebEvent_Events' AND COLUMN_NAME = N'EventSequence';
--
Dave Sexton
<carlospedr@xxxxxxxxx> wrote in message news:1155904370.999798.24820@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
I'm using .Net Framework 2.0.
I Querying an Sql 2000 Database to fill a Dataset, the user dynamically
choses what tables to query to fill the dataset. I need to provide
information to the user about the tables, information such as the type
and size of the columns.
Though at start this seemed to be quite simple to do, I have now came
to a problem when working with decimal columns. how can I get the
number of digits that a decimal column suports?
I have tried using sqlTypes when filling the table but not have been
able to get this info.
Can SomeBody Help me Please.
Carlos Pedro
.
- Follow-Ups:
- Re: SqlTypes Decimal
- From: carlospedr
- Re: SqlTypes Decimal
- References:
- SqlTypes Decimal
- From: carlospedr
- SqlTypes Decimal
- Prev by Date: Re: Stored Proc problem
- Next by Date: Re: Need some help on forms
- Previous by thread: SqlTypes Decimal
- Next by thread: Re: SqlTypes Decimal
- Index(es):
Relevant Pages
|
