Andrew Diniz (2/19/2013)

---

Carlo Romagnano (2/19/2013)

---

The update may fails with error, if the default collation is case sensitive.

UPDATE GenderUpdate

SET Gender = CASE WHEN GENDER = 'M' then 'F' ELSE 'M'...

Andre Ranieri (2/19/2013)

---

Since statement #4 either works OR it doesn't, a false answer would be impossible.

That's just my boolean mind at work.

Thanks for the question, and the nice use of...

Wow, interesting... and very odd.

I'd be curious to know the reason behind this restriction.

Unless I'm missing something, you would update it the same way you would if it were a physical table:

with SimpleUpdate as (Select Source, Sink, MovingAverage From TestNode)

UPDATE A

SET A.MovingAverage= B.MovingAverageResult

FROM...

Ugh, apparently I really need to use MERGE more often.

Thanks for the great question!

Nice question! Glad to see one involving cross joins.

archie flockhart (2/12/2013)

---

I selected "none of these are correct".

The first two are wrong for the reasons stated in the answer.

The third...

Even if you ignore...

I got lucky in guessing that the intent of the question was to show that you can't use INTO with an existing table, and that the answer really meant statements...

Nice question!

Full text indexing isn't something I use... had to do a bit of research on this one.

Based on what I read, it looks like even if you had removed...

Good question!

I wondered about an ALTER VIEW statement being there as well since altering the view inherently refreshes it, but then recalled that *'s aren't allowed in schema-bound objects. ...

Great question, thanks Tom!

Good question, as this seems to be very confusing for people with a programming background that start working with SQL.

Nice question. I'm surprised more people haven't gotten it correct, as it wasn't too hard to verify.

Nice creative question.

I think that is the first time I've seen a bit column used as a primary key.

There is not enough information to know if either model...