Answers for "sql server check decimal value"

SQL

5

sql server decimal

-- DECIMAL(p,s)     p: number of digits (lkeft+right)  s: number of digits (right)
-- NUMERIC and DECIMAL are synonyms
CREATE TABLE test.sql_decimal (
    dec_col DECIMAL (4, 2)		-- Max total 4 digits, including 2 after decimal
);
INSERT INTO test.sql_decimal (dec_col) VALUES (10.05);		-- OK 4 digits
INSERT INTO test.sql_decimal (dec_col) VALUES (21.0425);	-- KO

Posted by: Guest on July-08-2021

Source

Code answers related to "sql server check decimal value"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#