Showing posts with label evaluation. Show all posts
Showing posts with label evaluation. Show all posts

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.