-- For Int8 simulation, we use SMALLINT with a CHECK constraint between -128 and 127. Int8_Col SMALLINT NOT NULL CHECK (Int8_Col BETWEEN -128 AND 127), Int8_Nullable SMALLINT NULL CHECK (Int8_Nullable ...
It seems like an elementary thing but dealing with numbers beyond whole integers in software is tricky. Differences between rounding in code vs rounding in database storage can catch you off guard if ...