Advertisement

10.19.2006 at 12:10PM PDT, ID: 22030999
[x]
Attachment Details

SQL Server Trigger how do I know what columns are updated when I do have 150 columns in a table

Asked by wilkersons in MS SQL Server

Tags: trigger, sql, server, updated, column

I have a sql server table that has 150 columns. I wrote a trigger that sends an email to me telling me about some fields from this table. New Information  added or already existing info updates. I only deal with around 15 columns here. I wanted to know, in case of update, what all columns are actually updated. I don't want to write each and every column to see if it is updated. Columns_Updated i don't know the logic behind it. Please suggest. Thanks.Start Free Trial
 
Keywords: SQL Server Trigger how do I know wh…
Title
1 trigger
2 Trigger for forms
3 trigger question
4 SQL Server trigger
5 Can I reference column names symboli…
6 Trigger Expert Needed (again)
 
Loading Advertisement...
 
[+][-]10.19.2006 at 12:20PM PDT, ID: 17768793

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: trigger, sql, server, updated, column
Sign Up Now!
Solution Provided By: Sirees
Participating Experts: 4
Solution Grade: A
 
 
[+][-]10.19.2006 at 12:56PM PDT, ID: 17769120

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]10.19.2006 at 02:28PM PDT, ID: 17769929

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.19.2006 at 07:05PM PDT, ID: 17771124

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]11.12.2006 at 09:57AM PST, ID: 17925656

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]11.16.2006 at 09:34PM PST, ID: 17962820

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32