Share this Page URL
Help

Chapter 14. Understanding Access Project... > Creating SQL Server Tables in an Acc... - Pg. 517

Understanding Access Projects Access Data Type Number (Double) SQL Server Data Type(s) float SQL Server Data Type Description 517 Stores positive values between approximately 2.23E-308 through 1.79E+308, or negative values between approximately -2.23E-308 through -1.79E+308. The data type money stores monetary values in the range -922,337.203,685,477.5808 through 922,337,203,685,477.5807. The data type small- money stores monetary values in the range -214,748.3648 through 214,748.3647. The value is rounded up to two decimal places when it is dis- played. The data type decimal is an exact data type that holds values from -1038E-1 through 1038E-1. Al- lows you to specify the precision (the maximum total number of digits) and the scale (the maximum number of digits to the right of the decimal point).The data type numeric is an exact data type that holds values from -1038E-1 through 1038E-1. It allows you to specify the precision and the scale. The data type datetime is a date-and-time data type that ranges from January 1, 1753, through Decem- ber 31, 9999, with an accuracy of 3.33 millisec- onds.The data type smalldatetime ranges from Jan- uary 1, 1900, through June 6, 2079, to an accuracy of 1 minute. Stores a whole number in the range -2,147,483,648 through 2,147,483,647. varchar(n) is a variable-length data type with a maximum of 8000 ANSI characters.nvarchar(n) is a variable-length data type with a maximum of 4000 Unicode characters. A variable-length data type with a maximum of 2,147,483,647 characters; the default length is 16. A variable-length data type that holds a maximum of 2,147,483,647 bytes of binary data. Used to store Binary Large Objects (BLOBs) such as pictures, documents, sounds, and compiled code. A 16-byte GUID. See descriptions for these specific data types. A variable-length data type with a maximum of 8000 bytes of binary data. A data type that's automatically updated every time a row is inserted or updated. Values in timestamp columns are not datetime data but binary (8) or varbinary(8), indicating the sequence of data mod- ifications. char is a fixed-length data type with a maximum of 8000 ANSI characters. nchar is a fixed-length data type with a maximum of 4000 Unicode characters. Stores data of several data types, except for text, ntext, image, timestamp, and sql_variant types. Used in a column, parameter, variable, or return value of a user-defined function. A definition of the type of data that a column can contain, defined by the user with existing system data types. Rules and defaults can be bound only to user-defined data types. Currency money, smallmoney Number (Decimal) decimal, numeric Date/Time datetime,smalldatetime AutoNumber (Increment) Text (n) int (with the Identity property de- fined) varchar(n), nvarchar(n) Memo OLE Object text image Number (Replication ID)--a glob- ally unique identifier (GUID) Hyperlink No equivalent No equivalent uniqueidentifier (in SQL Server 7 or later) char, nchar, varchar, nvarchar (with the Hyperlink property set to Yes) varbinary timestamp No equivalent char,nchar No equivalent sql_variant No equivalent user-defined