Thanks...

Heh... guess that's why they call it "Mumps"... sounds like a real pain in the neck 😉

GSquared (3/20/2008)

---

Thanks Jeff.

On the use of Insert in the trigger, that gives me a date the data was first created, and by whom. I don't like having "CreatedDate" and...

Just a couple of suggestions... some in the form of questions...

First, what is the purpose of an audit log? Think about it carefully... what is the ONLY purpose for...

Matt Miller (3/20/2008)

---

GilaMonster (3/19/2008)

---

Matt Miller (3/18/2008)

---

I'd have to agree. Just about the only thing preventing NOLOCK would be a schema-lock, or something changing your DDL. Do you have...

See? That's what I mean... don't need 3rd party products for this type of stuff.

Thanks for the info, Mike...

When I started reading this, even the introduction sounded like a sales pitch. This isn't an article, it's an advertisment. I suppose it will be useful to some...

mukundbtech (3/20/2008)

---

but i like to know other than using extra files like BCP format or client side code or DTS , is there we can implement in a single...

Heh... depends... will meatloaf hold up in a slingshot? 😉

And now, I have a target... 😛 Dunno if I can beat the awesome speed of Regex, but I'll sure...

Heh... bring it on... you and I have both been bragging about how your Regex stuff is the only CLR that we've seen so far that could actually beat T-SQL...

JohnG (3/19/2008)

---

Actually, the MERGE statement was introduced in 9i (circa 2002) along with all of the new date and time datatypes that...

I've got an MS URL that explains the blocking in 6.5 somewhere. Lemme see if I can dig it up... I've always gotta prove these things so people don't...

I haven't looked it up and I'm no Oracle ninja especially where datatypes come in......

I figured that much out... I remember how big something like this got in DTS... that's why I was taking the T-SQL road... at...