Best way to store UInt32 on Sql server

Question

I am working on an application that uses a third-party component, and this component returns a value of type UInt32.

I need to save this UInt32 in a Sql Server table. I thought to just use a simple int column and insert a value like this:

int value = (int)(cs - int.MaxValue);

But I'm not sure if this is the best way to do this.

Answer 1

You should probably take + int.MinValue. Since max is 2147483647 and min is -2147483648 for a 32-bit signed integer. Zero steals one value from the positive side.

Answer 2

• bigint (10,0) , 0 4 .

• CLR

Answer 3

I suggest you store it in the bigint column.