SQL Server requires that each variable and column in a table should be defined with respect to the type of data it will store. From a bit to a huge image and binary storage types, the allocation is supposed to help the user conform to the data required, and help the engine allocate space and processing speed efficiently.
Built-in data types
SQL Server 2000 recognizes the following built in data types:
Data Types
Description
bigint
Integer data from -2^63 through 2^63-1
int
Integer data from -2^31 through 2^31 – 1
smallint
Integer data from -2^15 through 2^15 – 1
tinyint
Integer data from 0 through 255
bit
Integer data with either a 1 or 0 value
decimal
Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1
numeric
Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1
money
Monetary data values from -2^63 through 2^63 – 1
smallmoney
Monetary data values from -214,748.3648 through +214,748.3647
float
Floating precision number data from -1.79E + 308...
To view and download this full PLR article, you must be logged in. Registration is completely free. Once you create your account, you will be able to browse, search & downlod from our PLR articles database of over "1,57,897+" on 1,000's of niches and 200+ categories without paying a penny. Click here to signup...
