SQL SERVER - DATA TYPES
Numeric Data Types Data Type Description Length int Stores integer values ranging from -2,147,483,648 to 2,147,483,647 4 bytes tinyint Stores integer values ranging from 0 to 255 1 byte smallint Stores integer values ranging from -32,768 to 32,767 2 bytes bigint Stores integer values ranging from -2 53 to 2 53 -1 8 bytes money Stores monetary values ranging from -922,337,203,685,477.5808 to 922,337,203,685,477.5807 8 bytes smallmoney Stores monetary values ranging from -214,748.3648 to 214,748.3647 4 bytes decimal(p,s) Stores decimal values of precision p and scale s . The maximum precision is 38 digits 5–17 bytes numeric(p,s) Functionally equivalent to decimal 5–17 bytes float(n) Stores floating point values with precision of 7 digits (when n =24) or 15 digits (when n =53) 4 bytes (when n =24) or 8 bytes (when n =53) real Functionally equivalent to float(24) 4 bytes Date and Time Data Types Data Type Description Length Example date Stores...
