Friday, February 10, 2012

Bit more specific, Can one pass an NVARCHAR to IF UPDATED()?

Question is pretty much in the thread title.

I'm still plunking away on a history trigger that requires the evaluation of whether or not each column has been updated. If it has,t hen I'll be tossing a record into a history table.

Basically I need something to function along the same logic as this:

IF UPDATED(@.s)
BEGIN
--some code
END

Any thoughts you folks may have are greatly appreciated.About the closest I can get is the Columns_Updated() and maybe some fancy dancing with syscolumns.

-PatP|||About the closest I can get is the Columns_Updated() and maybe some fancy dancing with syscolumns.

-PatP

At least it's something to go on. I'll take a look at it tomorrow.

Much obliged good sir.

No comments:

Post a Comment