Number(10 2) in sql means

-- Precision of 10 and a scale of 2
SELECT CONVERT(DECIMAL(10, 2), col_name)

SELECT CONVERT(DECIMAL(10, 2), 2.999999)			-- 3.00
SELECT CONVERT(DECIMAL(10, 2), 12352.334)			-- 12352.33
SELECT CONVERT(DECIMAL(10, 2), 12564258524132.336)	-- Error: data truncation

Similar codes

0 vote130 views1 answer
Postgresql replace html tags from string
SQL
0 vote119 views1 answer
Dapper run sql script with parameters
SQL
0 vote133 views1 answer
Sql field equals multiple values
SQL
7 votes113 views2 answers
Phpmyadmin change password
SQL
0 vote111 views2 answers
Sqlite unique
SQL
0 vote132 views1 answer
Set Mamp mysql globally
SQL
0 vote109 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote137 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote121 views1 answer
Connect postgresql using a connection string
SQL
0 vote108 views2 answers
Sql count number of rows after group by
SQL