Answers for "SQL INT with max value"

SQL
12

mssql int max value

--			SIGNED										  UNSIGNED
--			Min               		Max                   Min Max
TINYINT     -128                    127                   0   255
SMALLINT    -32767                  32767                 0   65535
MEDIUMINT   -8388608                388608                0   16777215
INT         -2147483648             2147483647            0   4294967295
INTEGER     -2147483648             2147483647            0   4294967295
BIGINT      -9223372036854775808    9223372036854775808   0   18446744073709551615
Posted by: Guest on June-19-2021
-2

sql set max value in column

ALTER TABLE dbo.mytable ADD CONSTRAINT CK_HAPPINESS_MAX CHECK (PokemonHappiness <= 10000)
Posted by: Guest on October-30-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language