Which sql server data type best represents a double in C#?

views:

612

answers:

+5 Q:

Which sql server data type best represents a double in C#?

Is it money, float, real, decimal, _____ ?

+5 A:

Float is the sql type you are looking for.

Otávio Décio 2009-09-17 18:41:59

You are right that is the best match.Sadly Float is one of the worst datatypes you can use in SQL Server if you will need to perform math onthe field later as it creates rounding errors since it is not exact. As a dba I would not want people to define fields as float as I have had to deal with the mess they create when you want to do reporting on the data in the database and the calculations are incorrect.

HLGEM 2009-09-17 19:05:56

+10 A:

That would be float.

See Mapping CLR Parameter Data.

RedFilter 2009-09-17 18:42:32

+10 A:

Answer to this and all mapping of types can be found here.

http://msdn.microsoft.com/en-us/library/bb386947.aspx

David Stratton 2009-09-17 18:42:46

That chart is awesome, thanks for referencing it.

Matthew Vines 2009-09-17 18:44:15

winner by a chart, I just printed it out and rubbed it all over my eyeballs, thanks!

shogun 2009-09-17 18:56:00

+2 A:

float matches best. real is only 32 bits in precision, so essentially useless.

See: http://msdn.microsoft.com/en-us/library/ms173773.aspx

Philippe Leybaert 2009-09-17 18:43:08

ansaurus

tags:

views:

answers:

Which sql server data type best represents a double in C#?

related questions