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.
Friday, February 10, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment