Server New data type
After adding four new data types to SQL 7, SQL 2000 provides two new types of data, bigint and sql_variant respectively.
In today's increasing volume of data, int ( -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)) is used to denote integers that sometimes seem to be less than enough
Use, float is not very suitable, so VB 7 and SQL 2000 have a new integer type, this is bigint, it is the 8bytes integer type, the range is -2^63
(-9223372036854775808) to 2^63-1 (9223372036854775807).
As anyone familiar with VBScript knows, VBS uses a data type called a Variant. It can store any data type, number, character, object, etc. Sql
The sql_variant in 2000 has not yet been so powerful that it cannot store BLOB data, such as text, ntext and image, and timestamp, but has given
Programming has brought a lot of convenience.
Note that previous versions of ADO support for both data types are incomplete, and to use both types of data in your program, use MDAC 2.6
Next Period Notice:
User-defined Functions
Appendix:
New data type for SQL 7.0
1. UniqueIdentifier
One of the new data types in SQL 7 is the globally unique flag (GUID) for records, just like the CLSID we often see.
00020803-0000-0000-c000-000000000046
D54eee56-aaab-11d0-9e1d-00a0c922e6ec
There is a function that can generate a new Guid:newid ()
2. Char & VarChar & Binary & VarBinary
The maximum length has changed significantly, with the maximum length of these two data types being 255, and now 8000, which appears to be the result of Microsoft Learning to Oracle
3. NChar & NVarChar & NText
New data type, Unicode character type
