Trigger - NEED HELP PLEASE - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Trigger - NEED HELP PLEASE

Author

Topic

GenFX
Starting Member

2 Posts

Posted - 2004-10-07 : 06:40:40

Hi

I am new to SQL and i would like to do someting really simple.

Got to identical tables.
1. QADATA
2. QADATA_ARCHIVE

What needs to happen is that when someting gets inserted, updated or deleted on QADATA then that row/record must be inserted into QADATA.

Sounds simple but i can't get it to work.

Please help!!!

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2004-10-07 : 06:56:26

I'm assuming that on an update QADATA_ARCHIVE will just capture the 'before' version of the record.

CREATE TRIGGER TR_UD_QADATA
ON QAData
FOR UPDATE, DELETE

AS

INSERT INTO QADATA_ARCHIVE
(
Field1, Field2, etc.
)
SELECT
Field1, Field2, etc.
FROM deleted

CREATE TRIGGER TR_I_QADATA
ON QADATA
FOR INSERT
AS
INSERT INTO QADATA_ARCHIVE
(
Field1, Field2, etc.
)
SELECT
Field1, Field2, etc.
FROM inserted

Mark

GenFX
Starting Member

2 Posts

Posted - 2004-10-07 : 07:37:58

THANKS

WORKING GREAT....

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2004-10-07 : 07:54:25

No problem - glad to hear it!

Mark

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources