Steve Jones - SSC Editor (2/1/2011)

---

Well, had a nice adventure today. Water cut off mid-morning, took my daughter to the doctor so they could diagnose flu, and while thawing a...

The DELETED and INSERTED tables are built into SQL Server for use with Triggers.

See this MSDN page

http://msdn.microsoft.com/en-us/library/ms191300.aspx

Ever since the Michael Fish 'There is'nt hurricane coming' forecast the weather people have taken on the journalistic trait of predicting the worst possible scenario.

There won't be any snow settling.

But...

Thanks to all of you who took the time to comment on my question.

I've learnt something too from your suggestions: I'll be using the nullif tip and...

Thank-you both.

Apart from the cranky text editor and lack of syntax colouring, I'm quite enjoying a minor foray into Oracle.

Agreed!

There should be a rule for QOTDs and incorrect syntax.

How about, if a QOTD contains unintentional incorrect syntax, and the correct answer cannot be achieve without realising it,...

Glad you liked my question.

Not me - wrong continent - I'm in the UK.

Gotta tell you this

I heard some schoolkids singing on their way home

"Gordon Brown, Gordon Brown"

"He's dead but he won't lie down"

Hilarious! - who said the youth don't...

When I get an update/insert to work I usually try to select the restults I want first. For your query this line prevents prjid 2 from being updated at...

Paul White NZ (5/7/2010)

---

Hey I watched the BBC coverage on World News all day here (11am - 11pm and still going!)

BTW...

Thanks Hugo.

I'd never noticed those 'Predicate' parts of the plan before. Just goes to show, no matter how closely you investigate something, there is always more to learn.

@hugo

Thanks for that - I managed to follow your explanation - and I'm relieved to find out it has nothing to do with disk fragmentation (which was all...

coalition

(for all UK users 😉 )

Hugo Kornelis (5/7/2010)

---

I have to disagree with the comments so far. I do not consider this a very good question.

The processing order as described in the correct answer is the...

Thank-you all.

I've had this data for 10 years now, maybe I copied it from someone's SQL 2000 book - or possibly it came from an SQL 7 course I...