Or the ANSI standard COALESCE for the ANSI pedants among us :o) Has the added advantage of being able to take more than two operands. It...

Indeed. ANSI NULLS disabling is just a workaround I think for backwards compatibility with something.

Essentially an 'IF A = B' statement is saying that is (A = B) returns...

True - quite difficult to extract the actual content. Spose we could have waited for it on email...

I mistakenly interpreted 'not @i = 1' as being the same as '@i...

Tags DID make me choose the wrong option. I assumed it was asking about some subtlety of how sqlserver deals with unexpected xml elements. As such, I too reckon I...

I wouldn't have had a clue, except that the question category gave it away somewhat :o)

I'd have to disagree. I think these ones about working out pointless conditions to satisfy one off special cases...

Mikebyrne000 (3/7/2008)

---

Two question

1) I'm not clear as too what SET w.col1 = i.col1,

w.col2 = i.col2, does and how to apply same to my table

2) How to I actually write...

TRIGGER is fine - that's both types. You declare it as a TRIGGER usually 'FOR UPDATE, INSERT,...

I have lots of photographs that I have taken, and presumably own. And if they were of interest to people and I wanted to sell them, would I be allowed?...