Now a day’s lots of people ask interview questions around SQL Server data type and this is one is making lot of rounds during SQL Server interviews.
Money data type is the most suited data type for storing financial values as they are accurate ten-thousandth of the unit they represent. In financial figures accuracy matters. Small cents add up to millions later.
Further money data type has two variations “money” and “smallmoney”. Money has 8 bytes of storage while small money has 4 bytes of storage.
This in awesome SQL Server interview question video: - Can SQL Server views be updated?