What to use Float or numeric(180)

Question

Hi I have table called MaterialRequest ReqNo numeric(180) ReqNumber nvarchar(50) ReqQty numeric(182) or Float What is the best data type which should i used? and also for amount numeric or float Thanks Basit.

Midhun T P · Answer

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

basit khan · Answer

becoz sometime qty in decimal Example data type numeric(183) 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.

Suvendu Shekhar Giri · Answer

Which database are you using? If SQL Server you can use BIGINT . :)

What to use Float or numeric(18,0)