Trigger - 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

Transact-SQL (2000)

Trigger

Author

Topic

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2005-07-28 : 04:13:06

Hi All,

Is there any way i can write one trigger for all Insert Update And Delete

Something like

If (Insert)
............
Insert code here..

if (Update)
.........
Update Code here.

if (Delete)
......

Delete Code here...

Thanks in Advance..

.

Complicated things can be done by simple thinking

emilg
Starting Member

13 Posts

Posted - 2005-07-28 : 06:00:45

Why don't you want to put an individual trigger for each?

create trigger trg_xxx_ins on YourTable
for insert
as
...
go

create trigger trg_xxx_upd on YourTable
for update
as
...
go

create trigger trg_xxx_del on YourTable
for delete
as
...
go

In one trigger it should be:

create trigger trg_xxx_ins on dbo.TableA
for insert, update, delete
as

-- insert 
if exists (select * from inserted)
	and not exists (select * from deleted)
begin
	Print 'This was an insert!'
end

-- update
if exists (select * from inserted)
	and exists (select * from deleted)
begin
	Print 'This was an update!'
end

-- delete
if not exists (select * from inserted)
	and exists (select * from deleted)
begin
	Print 'This was a delete!'
end

go