Actually - if I remember correctly, a "natural join" is what you get when using some of the newer join commands like INTERSECT or EXCEPT. There isn't a specific...

Sorry - I did in fact mean Instead of (since they can be made to implement like a BEFORE sorta like).

I don't let tables get updated ad-hoc, so I can't...

Adam Hardy (11/11/2008)

---

Guys, your making me suck eggs here,

Yes data integrity tasks on the most part can be modelled with PKs and FKs. Those that can't, can be modelled with...

I can confirm that the identity order is definitely that imposed by the ORDER by during the insert. And since the autoincrement (or identity) column is the primary key,...

The problem I'm seeing is that if you simply exit the proc and term the batch, you now have an orphan, uncomittable transaction. This path then leads to the...

krayknot (11/10/2008)

---

Actually - that's not at all the case. There are many ways gaps...

rbarryyoung (11/10/2008)

---

OMG, you are killing me here Matt! I am using Service Broker with WAITFOR,...

rbarryyoung (11/10/2008)

---

Matt Miller (11/10/2008)

---

A TRY/CATCH in the calling context will deal with it. As long as you deal with it before the end of the batch you should be...

Or - use a WAITFOR with a Service Broker Group conversation handle....No loop.

The initial catch just suppresses the error (it didn't abort the trx at all). you just have...

This may not be ideal - but you could set up a DB version of a dead man's switch. That is - set up a WHILE loop with a...

A TRY/CATCH in the calling context will deal with it. As long as you deal with it before the end of the batch you should be okay.....

begin try

exec barry

END...

Well - I personally try to avoid nesting my transactions (since ultimately only the outer one "counts"), but that being said - if I'm worried about scoping and knowing what's...

This would bring out the old Bastard DBA from Hell in me. Just encrypt all of the views and all outputs from the DB, calling it a new SOX...

I know it's not always possible - but putting the thousand separators into numbers is a UI function, so it's usually best ot leave that up to the UI to...

This sounds like fun.

I'll see your Hints Hell, and I'll raise you a Windowed Aggregate function with a misapplied distinct:

select distinct * from

(

SELECT CompanyName, OrderDate, ProductName, OD.UnitPrice,...