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

18 votes303 views3 answers
Mysql query add column with default string value
SQL
0 vote303 views1 answer
Mysql use password error
SQL
0 vote289 views2 answers
Update all linkedserver tables with openquery on db
SQL
8 votes306 views2 answers
Change name of colum in sql table
SQL
0 vote306 views1 answer
Zerar auto increment mysql
SQL
0 vote316 views1 answer
Postgresql create query
SQL
0 vote313 views1 answer
Openquery insert into linked server
SQL
0 vote307 views1 answer
Linebreak sql
SQL
3 votes302 views1 answer
Select table column in sql
SQL
7 votes319 views4 answers
What is my mysql version
SQL