Print Page | Close Window

SQL Server Data Type Compatibility

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=2355
Printed Date: 13-Sep-2025 at 11:51am


Topic: SQL Server Data Type Compatibility
Posted By: HaySeed
Subject: SQL Server Data Type Compatibility
Date Posted: 08-Dec-2010 at 1:59pm
I have c# classes that use double as the data type of choice for properties that require precision to the 12th decimal. I am attempting to persist the objects using Ideablade classic into SQL Server 2005.

As I'm sure you know, SQL server 2005 has no data type for double.  Using Numeric(x,y) or Decimal(x,y) produces an "Arithmetic Overflow" error.  What SQL Server data type should I use to support a C# double?
 



Print Page | Close Window