without the it is rather obvious that the table would still be created but a warning will be given.

As long as you insert/update so combined they are smaller then 900bytes.

I choose the because of , thought i was to think about names of tables! .. so that you had the include [ ]

Create table [sales2]

(

COL1 varchar(20) not null,

COL2 varchar(600) not null,

COL3 varchar(400) not null,

date datetime not null,

Unique clustered (COL2, COL3)

)

Same as getting a error when using create table a e instead of create table [a e]

At least when giving a question make sure that the question is right!

Please remove question because a lot of people would have it right!