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 vote181 views1 answer
How to find unique key in sql
SQL
7 votes208 views1 answer
Grant schema permissions postgres
SQL
1 vote263 views1 answer
Pentaho + pasar de excel a sql
SQL
17 votes233 views1 answer
Selecting name that contain certain word in sql
SQL
1 vote215 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
2 votes226 views1 answer
Power query concatenate
SQL
0 vote187 views1 answer
Sql random decimal
SQL
0 vote202 views1 answer
To change the database owner in SQL server
SQL
10 votes184 views2 answers
Sql where clause multiple values
SQL
0 vote209 views2 answers
Plsql function that return a table
SQL