venoym (4/10/2014)

---

Guess I'll be the first to say that the "twist" was not appropriate. The question was titled and about the TRY...CATCH structure in SQL Server, the string length...

TomThomson (4/3/2014)

---

Sean and myself were talking about a situation where the DB structure had already been fixed, so indexes and keys...

Sean Lange (4/3/2014)

---

Good call on the bit field. I try to avoid them myself, so...

I think the trigger still contains a logic error...

Currently it updates the datechanged even if the values remain the same. Maybe if the field was called DateUpdated a change wouldn't...

@Anoo

This is exactly what happened to me and how I found out about this behaviour.

In many programming languages the third argument wouldn't even be evalutated if the second argument didn't appear in the first argument.

All these will just return 'ABC':

SELECT REPLACE('ABC', 'Z', 1)

SELECT REPLACE('ABC',...