What to use Float or numeric(18,0)

Hi,

Please go through below threads -

http://stackoverflow.com/questions/1056323/difference-between-numeric-float-and-decimal-in-sql-server

http://www.techbrothersit.com/2016/02/what-is-difference-between-float-and.html

becoz sometime qty in decimal

Example data type numeric(18,3)

Qty

1.410

1.4110

12.300

if i use float the o/p will be

Qty

1.41

1.411

12.3

what my question is which datatype is good?

Thanks

Basit.

Which database are you using?

If SQL Server, you can use BIGINT.

:)