Use of data types Money and Smallmoney in RDBMS(Sql Server)

Money and Smallmoney: -

These are the data types to store the monetary or currency values in the data type. Money data type stores the 8 bytes and Smallmoney data type stores the 4 bytes. These data types are capable to store the ten-thousandth of the monetary unit. For example:- cents and dollars etc. 6) Int, bigint, smallint and tinyint:- These data types can also stores the exact values of the number. int data type is the primary integer data type in the SQL Server. We can use the bigint data type in place of the int and small int if the records are too much in the given table. But if the data is keep increasing in the table then we can change the data type of the monetary column into bigint from tinyint, smallint and int. The use of the different data type from the int family is used as per the requirements which are different all the time. For Metadata/ Base tables may be able to use the tinyint and smallint but for the transaction tables we can go for the int and bigint data types.