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!