Can you create a trigger on a field within a table?

Posted by chris on Stack Overflow See other posts from Stack Overflow or by chris
Published on 2010-03-18T17:47:36Z Indexed on 2010/03/18 17:51 UTC
Read the original article Hit count: 346

Filed under:

sqlserver-2008

|

trigger

Is it possible to create a trigger on a field within a table being updated?

So if I have:

TableA
  Field1
  Field2
  ....

I want to update a certain value when Field1 is changed. In this instance, I want to update Field2 when Field1 is updated, but don't want to have that change cause another trigger invocation, etc...

© Stack Overflow or respective owner

Related posts about sqlserver-2008

SQLServer 2008 BIDS On Windows 7 - 64bit

as seen on Server Fault - Search for 'Server Fault'
Hello, I am trying to install Sql Server 2008 Business Intelligence Development Suite on VS2008 in a Windows 7 (64bit) machine. The installer is aborting with an unspecified error for which I have not been able to find any error anywhere. Has anyone had the same problem with BIDS? Thanks, Eduardo… >>> More
Setup of SQLServer 2008 want to reboot

as seen on Server Fault - Search for 'Server Fault'
I want to setup a sqlserver 2008 developeredition on my windows-vista notebook but the setup-check want me to reboot first. But this doesn't help after reboot the setup want a reboot again. I got the tip: You can open Regedit, and modify this key"HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet?\Control\Session… >>> More
SQLServer 2008 Fails to start under NT AUTHORITY/NETWORK SERVICE account

as seen on Super User - Search for 'Super User'
Not sure what changed but looks like my security credentials have been monkeyed with. Since yesterday evening after I disconnected from our corporate network and rebooted my laptop at home, I am unable to start the instance of SQL2K8. The service is set to run under NT AUTHORITY\NETWORK SERVICE account… >>> More
SQLServer 2008 FailOver and Load Balancing

as seen on Server Fault - Search for 'Server Fault'
I have a project with a 2TB database ( 450.000.000 rows). I need to provide to the proyect a solution that gives FailOver and load Balacing, what do you recommend? We are going to use a NetApp Filer for the Data Files and for the File System of the Proyect. I read that SQl Clustering does not provide… >>> More
Multiple rows with a single INSERT in SQLServer 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
I am testing the speed of inserting multiple rows with a single INSERT statement. For example: INSERT INTO [MyTable] VALUES (5, 'dog'), (6, 'cat'), (3, 'fish) This is very fast until I pass 50 rows on a single statement, then the speed drops significantly. Inserting 10000 rows with batches of 50… >>> More

Related posts about trigger

consistency of Trigger Procedure (before row trigger) Postgresql

as seen on Stack Overflow - Search for 'Stack Overflow'
Using Postgresql. I try to use TRIGGER procedure to make some consistency check on INSERT. The question is ...... whether "BEFORE INSERT FOR EACH ROW" can make sure each row to insert "checked" and "inserted" one after another? do I need extra lock on table to survive from concurrent insert? check… >>> More
mutating, trigger/function may not see it- error during execution of trigger

as seen on Stack Overflow - Search for 'Stack Overflow'
CREATE OR REPLACE TRIGGER UPDATE_TEST_280510 AFTER insert on TEST_TRNCOMPVISIT declare V_TRNCOMPNO NUMBER(10); CURSOR C1 IS SELECT B.COMPNO FROM TEST_TRNCOMPVISIT A, TEST_TRNCOMPMST B, TEST_MEMMAST C WHERE A.COMPNO=B.COMPNO AND B.TRNMEMID=C.MEMID AND C.MEMOS=1000; begin open c1; fetch c1 into… >>> More
Behaviour of insertion trigger when defining autoincrement in Oracle

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been looking for a way to define an autoincrement data type in Oracle and have found these questions on Stack Overflow: Autoincrement in Oracle Autoincrement Primary key in Oracle database The way to use autoincrement types consists in defining a sequence and a trigger to make insertion… >>> More
Returning Identity Value in SQL Server: @@IDENTITY Vs SCOPE_IDENTITY Vs IDENT_CURRENT

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
We have some common misconceptions on returning the last inserted identity value from tables. To return the last inserted identity value we have options to use @@IDENTITY or SCOPE_IDENTITY or IDENT_CURRENT function depending on the requirement but it will be a real mess if anybody uses anyone of these… >>> More
Returning Identity Value in SQL Server: @@IDENTITY Vs SCOPE_IDENTITY Vs IDENT_CURRENT

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
We have some common misconceptions on returning the last inserted identity value from tables. To return the last inserted identity value we have options to use @@IDENTITY or SCOPE_IDENTITY or IDENT_CURRENT function depending on the requirement but it will be a real mess if anybody uses anyone of these… >>> More