MySQL - MS SQL Server data types?

Hi

I am modelling a design in MySQL and MS SQL Server 2000 Personal Edition.

I have never really used the MS offering and I just started looking/reading up about it and have the following question regarding data type equivalents.

What is the MS SQL Equivalent of the following (from MySQL):

----

xxx INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

VARCHAR(200),

LONGTEXT,

----

Thanks.

Mak.

<<
xxx INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

VARCHAR(200),

LONGTEXT,
>>


i think you cannot have auto incement directly in the create statement.

but you can have this:

xxx INT NOT NULL PRIMARY KEY,

you can use same varchar type in MSSQL:


VARCHAR(200),


You may use the "text" or "ntext" datatype in MSSQL instead of long text.

TEXT,

for auto increment number ,you need to create a "sequane" in sql and insert that while you issue sql statement.

Try this for creating an auto incrementing PK

INT NOT NULL IDENTITY PRIMARY KEY

Optionaly you can chane the seep and increment thus:

INT NOT NULL IDENTITY(seed, increment) PRIMARY KEY