sql - SQL Server中的数字，浮点数和小数之间的差异(Difference between numeric, float and decimal in SQL Server)

Question

I searched in Google and also visited decimal and numeric and SQL Server Helper to glean the difference between numeric, float and decimal datatypes and also to find out which one should be used in which situation. (我在Google中进行了搜索，还访问了十进制和数字以及SQL Server Helper，以收集数字，浮点和十进制数据类型之间的差异，并找出在哪种情况下应使用哪种。)

For any kind of financial transaction (eg for salary field), which one is prefered and why? (对于任何形式的金融交易（例如，薪水领域），首选哪种交易，为什么？)

  ask by priyanka.sarkar translate from so