Stored Procedure

Question

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Robert-378556 SSCertifiable Points: 5976 More actions · Answer 1

insert into T2 select * from T1 where ;

delete from T1 where ;

You can put it into T1 trigger too, so you don't have to manually call the SP:

create trigger t1_xy on T1 for insert, update

as

insert into T2 select * from inserted where ;

delete from T1 join inserted on ;

Simple as that. Homework? exam question?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Actually, if you need to move the record from Table1 to Table2 on delete, you would use a trigger that fired ON DELETE to move the record.

😎

Robert-378556 SSCertifiable Points: 5976 More actions · Answer 3

oops, of course. I reread the original post again. I should be more careful.

Grant Fritchey SSC Guru Points: 399330 More actions · Answer 4

Use the OUTPUT clause from the DELETE statement to insert the data as it gets removed.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Definately another way to do it. Haven't used it myself yet, but should look at when needed.

😎