Database datatypes: sql server 2000 support

[raymondsing]

Hi everyone,

1) Does anyone know whether the datatypes in sql server 7 and 2000 are the same? If not, would u like to have support for 2000?

2) If I want to reverse engineer from an existing database, does it make a difference whether i select the database datatypes before and after importing?

cheers!

[Ilia]

Hi
"SQL Server 2000 introduces three new data types. bigint is an 8-byte integer type. sql_variant is a type that allows the storage of data values of different data types. table is a type that allows applications to store results temporarily for later use."
You can define new data types for sql server 2000 in Reference \ Database Datatypes if you like.