Posted by Hugo Kornelis on 08/03/07 18:58

On Fri, 03 Aug 2007 09:44:41 -0700, ben@jammin.co.uk wrote:

>I would like to know if it is possible to use a variable to use with
>the IF UPDATE(column) statement. Only, the column should be a variable
>[e.g. IF UPDATE(@column_name)] which should be substituted at run-time
>with the real column name.
>
>TIA

Hi ben,

That's not possible. You might want to look at COLUMNS_UPDATED()
function instead.

Or better yet, explain here what you're trying to do and why you think
that a dynamic IF UPDATE(xxx) would help you. There's a good chance that
there's a better way to do it!

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

[Back to original message]