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

[Back to original message]