COLUMNS_UPDATED() Dangerous?

#1

Dear SQLer:

I am just reading up about COLUMNS_UPDATED(), and it appears to
be dangerous.

It seems to me that a trigger using it would be vulnerable to
breaking if a change were made in the structure of the table.

Am I correct, or am I missing something?

Sincerely,

Gene Wirchenko

#2

Gene Wirchenko (genew (AT) ocis (DOT) net) writes:

Quote:

I am just reading up about COLUMNS_UPDATED(), and it appears to
be dangerous.

It seems to me that a trigger using it would be vulnerable to
breaking if a change were made in the structure of the table.

Am I correct, or am I missing something?

No, you are correct. I find this function to be of very dubious value.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#3

On Thu, 24 Feb 2011 09:57:22 +0000 (UTC), Erland Sommarskog
<esquel (AT) sommarskog (DOT) se> wrote:

Quote:

Gene Wirchenko (genew (AT) ocis (DOT) net) writes:
I am just reading up about COLUMNS_UPDATED(), and it appears to
be dangerous.

It seems to me that a trigger using it would be vulnerable to
breaking if a change were made in the structure of the table.

Am I correct, or am I missing something?

No, you are correct. I find this function to be of very dubious value.

Thank you. I was surprised to see something so dubious-looking.

Sincerely,

Gene Wirchenko

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

COLUMNS_UPDATED() Dangerous?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

COLUMNS_UPDATED() Dangerous? - 02-23-2011 , 07:23 PM

Re: COLUMNS_UPDATED() Dangerous? - 02-24-2011 , 03:57 AM

Re: COLUMNS_UPDATED() Dangerous? - 02-24-2011 , 04:10 PM