Statement causes error

Question

Dear All,

What's wrong with the statement "create index engnamestuid on engname + cast(student as nvarchar(6))"?

Answer 1

DDL statements like CREATE INDEX requires fix literal, you can not use "calculated object names".