Does Microsoft SQL Server support unsigned integer data types?
I am trying to learn a bit more about the data type choices and helping a friend in his database project, I know that MySQL does.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
No. The numeric data types are all signed.
For example an int is from approx. -2^31 to +2^31.
If you have a value just shy of 2^32 you will have to use a larger data type such as bigint. There are finer points here, but out of scope of this discussion.
Related Q & A:
You can easily emulate unsigned 32-bit int with your regular, signed bigint. Do whatever arithmetics needs to be done, AND with 0xFFFFFFFF for every operation that may potentially overflow the lower 32 bits.