Friday, January 12, 2018

NUMERIC datatypes in T-SQL for unsigned numbers

A find Pinal Dave's blog some when I Google and this post in particular says: I can use NUMERIC(20) datatype for 64-bit unsigned integer value, NUMERIC(10) datatype for 32-bit unsigned integer value and NUMERIC(5) datatype for 16-bit unsigned integer value. An unsigned numeric type starts at zero and counts upwards until its cap such as uint in C# while a signed numeric types like int in both C# and T-SQL and what is Int64 in C# but bigint in T-SQL instead have a range straddling zero with half of the capacity allowing you to count downwards into negative numbers. The u in uint must stand for unsigned I guess.

No comments:

Post a Comment