Posted by Erland Sommarskog on 06/12/07 07:13

Jeff Kish (jeff.kish@mro.com) writes:
> so avoid float because it is a non exact storage and that makes it
> dubious for part of a key, or is it just because floats are inherently
> bad in a pk for performance reasons?

The former. For performance it is as good as any other bit pattern. But that
is of little interest when you may fail read rows because your input bits
does not match the table bits.




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: How calculate space that occupied?
• Prev in forum: Re: SQL Server 2005 with VB.net 2005
• Thread view: Re: float storage and usage

[Reply to this message]