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: 10-Jun-2026 at 6:04am


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