number 2810 2 29 in sql means

Solutions on MaxInterview for number 2810 2 29 in sql means by the best coders in the world

showing results for - "number 2810 2 29 in sql means"
Clément
16 May 2017
1-- Precision of 10 and a scale of 2
2SELECT CONVERT(DECIMAL(10, 2), col_name)
3
4SELECT CONVERT(DECIMAL(10, 2), 2.999999)			-- 3.00
5SELECT CONVERT(DECIMAL(10, 2), 12352.334)			-- 12352.33
6SELECT CONVERT(DECIMAL(10, 2), 12564258524132.336)	-- Error: data truncation