|
|
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
Navigation:
[Reply to this message]
|