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 vote275 views1 answer
T-SQL Create Trigger
SQL
0 vote247 views1 answer
Is numeric in sql
SQL
1 vote260 views1 answer
Psql client write to bash variable
SQL
14 votes275 views2 answers
Oracle add column with default value
SQL
1 vote271 views1 answer
Sql dcl
SQL
3 votes253 views1 answer
Oracle user quota unlimited
SQL
9 votes284 views4 answers
Postgresql export database
SQL
7 votes246 views1 answer
Grant schema permissions postgres
SQL
0 vote262 views1 answer
Create mysql pool connection python flask
SQL
0 vote213 views1 answer
Ms sql print more than 1 variable
SQL