create table t (id int,c int)
insert into t select 1,1
insert into t select 2,2
go
create trigger tt
on t
after insert
as
update t
set c=(select max(c)+1 from t)
goinsert into t select 3,3select * from t
drop trigger tt
drop table t
insert into t select 1,1
insert into t select 2,2
go
create trigger tt
on t
after insert
as
update t
set c=(select max(c)+1 from t)
goinsert into t select 3,3select * from t
drop trigger tt
drop table t
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货