Chapter 2 DATABASE DESIGN FOR SQL SERVER 2000
Chapter 2 DATABASE DESIGN FOR SQL SERVER 2000 89 characters, whereas ntext can store 1,073,741,823. Binary Data Types A number of data types are used to store binary data. The smallest is the bit data type, which supports Boolean operations and stores values of 0 or 1 in a single storage bit. Other binary data types are used to store binary strings and are stored as hexadecimal values. Binary data is stored using the binary, varbinary, and image data types. A column assigned the binary data type must have the same fixed length of up to 8KB. In a column assigned the varbinary data type, entries can vary in size. Columns of image data can be used to store variable-length binary data exceeding 8KB, such as Microsoft Word documents, Microsoft Excel spreadsheets, and images that SQL-92 Standard Timestamp The T-SQL timestamp data type is not the same as the timestamp data type defined in the SQL-92 standard. The Specialty Data Types SQL-92 timestamp data type is equiv alent to the T-SQL datetime data type. include bitmaps and other graphic files. Many data types are used in special circumstances to store data that does not directly qualify as numeric, character, or binary. Data types are available to store time and date information, globally unique identifiers (GUID), cursors, and tables. Three data types support the storage of time and date information: datetime, smalldatetime, and timestamp. All three store dates and times, although the timestamp data type stores automatically generated binary values using 8 bytes of storage and is not used to store data. Values with the datetime data type are stored as two 4-byte integers. The first 4 bytes store the number of days before or after the base date, which is January 1, 1900. The base date is the system reference date. Values for datetime earlier than January 1, 1753, are not permitted. The other 4 bytes store the time of day, represented as the number of milliseconds after midnight. The smalldatetime data type stores dates and times of day with less precision than datetime. It stores them as two 2-byte integers. The first 2 bytes store the number of days after January 1, 1900. The other 2 bytes store the number of minutes since midnight. Dates range from January 1, 1900, through June 6, 2079. The uniquidentifier data type stores a 16-byte data value known as NOTE
For high quality website hosting services please check java web hosting website.