请大家看看，如下形式的触发器如何写！！！急！

[eagle_hb]

col1 col2
---------
a 1
b 2
c 3
d 4
要求随便删除一行以后，如删除第二行后，第二行的col2后的值全部减1，
变成如下所示
col1 col2
-----------
a 1
c 2
d 3

[txlicenhe]

create trigger on yourTable
For Delete
As
update yourTable set col2 = col2-1
where col1 > (select col1 from deleted)

or:
create trigger on yourTable
For Delete
As
declare @a varchar
select @a = col1 from deleted
update yourTable set col2 = col2-1
where col1 > @a

[lifeforu]

create trigger t on table for delete
as
update test set col2=col2-1 where col2>(select col2 from deleted)

[CrazyFor]

和ID标识的跳号是一样的

TRY:
表的删除触发器中加:

update 表 set col2=(select count(*) from 表 bb where bb.col2<表.col2)+1

[dafu71]

ALTER TRIGGER [t_delete] ON [dbo].[yourtable]
FOR delete
AS
begin transaction
declare @pos int
select @pos=col2 from deleted
update yourtable set col2=col2-1 where col2>@pos
commit transaction
-------------------------接分

[chao778899]

create trigger on yourTable
For Delete
As
update yourTable set col2 = col2-1
where col1 > (select col1 from deleted)

[zjcxc]

create trigger t_delete on 你的表
For Delete
As
update 你的表 set col2 = col2-1
where col1 > (select min(col1) from deleted)