ms sql 2005 Insert,update,delete触发器类型判断问题？

[海会圣贤]

我想创建这样的触发器：

Create Trigger tr_PCard 
	On P_Card
	for Insert,Update,Delete

    if   update   --如果UPDATE执行一下程序 
    begin 
        ... 
    end 

    if   insert     --如果INSERT执行一下程序 
    begin 
        ... 
    end 

    if delete 
    begin
        ...
    end

但请问，insert,update,delete这些类型怎么判断啊？

[ws_hgo]

Create Trigger tr_PCard 
    On P_Card
    for Insert,Update,Delete

    if exists(select * from updated)
    begin 
        ... 
    end 

    if  exists(select * from inserted)
    begin 
        ... 
    end 

    if exists(select * from deleted) 
    begin
        ...
    end

[bancxc]

[Quote=引用 1 楼 ws_hgo 的回复:]
SQL code
Create Trigger tr_PCard
On P_Card
for Insert,Update,Delete

if exists(select * from updated)
begin
...
end

if exists(select * from inserted)
……
[/Quote]

[水族杰纶]

Create Trigger tr_PCard On P_Card
for Insert,Update,Delete
as
    if exists(select 1 from inserted) and not exists(select 1 from deleted)--insert触发器   
    begin 
        ... 
    end 
    else if exists(select 1 from inserted) and  exists(select 1 from deleted)--update触发器
     begin 
        ... 
     end 
    else --deleted触发器
      begin 
        ... 
      end 

[hao1hao2hao3]

[Quote=引用 3 楼 wufeng4552 的回复:]
SQL code
Create Trigger tr_PCard On P_Card
for Insert,Update,Delete
as
if exists(select 1 from inserted) and not exists(select 1 from deleted)--insert触发器
begin
...
end ……
[/Quote]

这个好像更严谨一点。

[「已注销」]

[Quote=引用 1 楼 ws_hgo 的回复:]

SQL code
Create Trigger tr_PCard
On P_Card
for Insert,Update,Delete

if exists(select * from updated)
begin
...
end

if exists(select * from inserted)
begin ……
[/Quote]
up