March 28th, 2004, 02:48 PM
|
|
Contributing User
|
|
Join Date: Mar 2004
Posts: 56
Time spent in forums: < 1 sec
Reputation Power: 5
|
|
I guess, the FOR EACH ROW statement is missing
CREATE TRIGGER name ON table BEFORE INSERT FOR EACH ROW AS...
Quote: | Originally Posted by qintonic If a record in the database is updated i want to write the value of one field in another field.
But i just want to update the actual row which was updated, and not all records. If i use this example, all records
will be affected...
CREATE TRIGGER [Name des Triggers] ON [dbo].[Tabellenname]
AFTER INSERT AS UPDATE Tabellenname set fieldxy = fieldAB
Thanks for help |
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
