I am using MS SQL Server 7.0.

Today I found a strange beahviour of SQL Server while createing a table. I gave the command as :

Create Table Test(
BidID int identity (1, 1) NOT NULL Constraint PK_SubInstAct28099 Primary Key (BidID),
TransID int NULL, BidTime datetime NULL , UserID varchar(15) NULL, )

By running this cammand it can create a table called Test.

I can't understand whether the saem is a bug of Microsoft or a feature of Microsoft as the same is syntactically wrong.

Can any one helps me out.

Thanks in advance.