sread (5/11/2011)

---

Won't the create table statement fail due to the comma after the last column name?

Richard Warr (5/11/2011)

---

A question that enables most people to get the correct answer after some careful thought is by no means "too simple". Especially as over 1/3 of respondants have got it wrong.

For me this was close to a "Goldilocks" question. For some it's too hard, for others too soft, but for many, it's just right.

Richard Warr (5/11/2011)

---

A question that enables most people to get the correct answer after some careful thought is by no means "too simple". Especially as over 1/3 of respondants have got it wrong.

For me this was close to a "Goldilocks" question. For some it's too hard, for others too soft, but for many, it's just right.

CREATE TABLE staff(
STAFFID INT IDENTITY(1,1) NOT NULL,
STAFFNAME VARCHAR(100))

CREATE UNIQUE CLUSTERED INDEX UCI_PK ON staff(STAFFID)