Hello,
I have a table called STUDENTS and STUDENTS_LOG.
I have created a TRIGGER on STUDENTS table that executes automatically when
I attempt to Insert or update the STUDENTS table. The trigger adds a record
into STUDENTS_LOG using the INSERTED logical table. This is to keep a
history of all modifications in the STUDENTS table.
------------------------------------
CREATE TRIGGER TRIG_STUDENT ON dbo.STUDENTS
FOR INSERT,UPDATE
AS
INSERT INTO STUDENTS_LOG SELECT * FROM INSERTED
-------------------------------------
STUDENTS table contains an IDENITY field. I use a stored procedure to add a
other purposes.
STUDENTS_LOG table does not contain any IDENTITY fields
This operation worked fine with SQL ver 6.5
command in the TRIGGER
Why?
Thankyou for your time.
Gina Geurgis
The University of Queensland