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 vote184 views1 answer
C# datetime to sql server datetime
SQL
0 vote193 views1 answer
Mariadb LOAD DATA INFILE
SQL
9 votes215 views4 answers
SQL Date Format
SQL
1 vote183 views1 answer
Local sql server
SQL
0 vote204 views1 answer
Postgresql function ROUND
SQL
1 vote218 views1 answer
Mysql select all and rename one
SQL
0 vote154 views1 answer
Copy data from cell to cell mysql
SQL
1 vote215 views3 answers
Postgresql crete view
SQL
2 votes360 views5 answers
Unique in sql server
SQL
1 vote163 views2 answers
Delete auto increment mysql
SQL