数据库系统概论第三章ppt概要1.pptVIP

第三章 关系数据库标准语言SQL 部分 第三章 关系数据库标准语言SQL 3.2 数据定义 一、SQL Server 2000中的数据类型 1、Integers bit ：Integer data with either a 1 or 0 value. tinyint ：Integer data from 0 through 255. smallint ：Integer data from -2^15 (-32,768) through 2^15 - 1 (32,767). int ：Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). 2、decimal and numeric decimal ：Fixed precision and scale numeric data from -10^38 -1 through 10^38 -1. numeric ：A synonym for decimal. 3、money and smallmoney money ：Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 第三章 关系数据库标准语言SQL 3.2 数据定义 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit. smallmoney ：Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit. 4、Approximate Numerics float ：Floating precision number data from -1.79E + 308 through 1.79E + 308. real ：Floating precision number data from -3.40E + 38 through 3.40E + 38. 5、datetime and smalldatetime datetime ：Date and time data from January 1, 1753, to December 31, 9999, with an accuracy of 第三章 关系数据库标准语言SQL 3.2 数据定义 three-hundredths of a second, or 3.33 milliseconds. smalldatetime ：Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute. 6、Numerics cursor ：A reference to a cursor. timestamp ：A database-wide unique number. uniqueidentifier ：A globally unique identifier (GUID). 7、Character Strings char ：Fixed-length non-Unicode character data with a maximum length of 8,000 characters. varchar ：Variable-length non-Unicode data with a maximum of 8,000 characters. text ：Variable-length non-Unicode data with a maximum length of 2^31 - 1 (2,147,483,647) characters. 第三章 关系数据库标准语言SQL 3.2 数据定义 8、Binary Strings binary ：Fixed-length binary data with a maximum len