Sql server datatypes , for storing a Positive number

Question

Hi i want to add a column inside my SQL Server 2008 R2, which stored a Switch Ports numbers , which always have positive numbers such as 1 ,2, 3 ,4 , 5,6 ,etc... I can use Integer, but is there a more appropriate data type for storing positive integers ? Thanks

Nope. int and a CHECK constraint if you want to be sure is about the best. — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Apr 25, 2014 at 10:55

Community · Accepted Answer · 2017-05-23 11:57:28Z

5

No, there is not. SQL server doesn't support unsigned integers.

Some more details on this can be found on Why doesn't SQL Server support unsigned datatype?

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered Apr 25, 2014 at 10:55

Tomas Pastircak

2,85718 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vignesh Kumar A · Accepted Answer · 2014-04-25 11:05:28Z

2

Tinyint

A SQL Server system datatype, it is a tiny integer column that holds whole numbers between 0 and 255, inclusive. Storage size is 1 byte.

The TinyInt allow you to insert Positive numbrs only but you can have values between 0 and 255...

See Demo here

SQL SERVER NUMERIC DATATYPE

edited Apr 25, 2014 at 11:05

answered Apr 25, 2014 at 10:56

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

Collectives™ on Stack Overflow

Sql server datatypes , for storing a Positive number

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related