And double-posting!

I'm afraid I don't follow what you're trying to do. What precisely do you mean by "I want to capture a case"? Are you talking about logging something,...

Lynn Pettis (4/1/2009)

---

Geez, some people with no sense of humor. I read it thinking it was a real horror story unfolding on a poor DBA. Glad to see...

I keep looking for SSC's hostile takeover over SQL Server from MS. 🙂

It looks like each customer number always has the same data for first and last name, just different data for first name 1, and last name 1. Is that...

If you don't need to audit col2 and col3, why include them in the select statement in the trigger? Why include them in the audit table?

arr.nagaraj (4/1/2009)

---

CREATE TABLE [dbo].[t3] (

[n1] [int] not null,

[n2] [int] not null,

[n3] as n1 + n2 ,

[n4] as n1 * n2

CONSTRAINT [t3_unique_key] unique (n3,n4)

...

That's correct. To achieve that, you have to set the isolation level to "read uncommitted". It's a related, but slightly different, thing.

Yep.

You can use the Update() function for this, if you prefer column names over ordinal positions.

jfox (3/31/2009)

---

I find it funny that Prius owner Steve Jones is all proud of his mpg ratings and 'savings'. My daughter bought a Yaris for a lot less that...

JJ B (3/31/2009)

---

Concerning the discussion on comfort: There's all kinds of comfort. I find the Civic Hybrid to be extremely comfortable in several ways. I'm not overly...

Oh, that's nothing. It's also got functions on...

mlang (3/31/2009)

---

The problem in this is that it's very hard to prove "lack of intent", just as it's hard to prove any negative. With lawyers and courts operating on...

Steve Jones Note that if you're not social in the real world, you probably won't like these things. If you don't like to talk about your life with co-workers, alumni,...