--如果直接在表中加这么个字段,中间断号后,不是很好处理。还不如直接在查询时,显示这个编号。如: select number=(select count(1) from 表名 where id<=a.id),* from 表名 a
用触发器试试吧,假设id为主键:create trigger trig_del on Material from delete as update a set Number=(select count(*) from number where id<=a.id) from Number a where exists(select 1 from deleted )
用触发器试试吧,假设id为主键: create trigger trig_del on Material for delete as update a set Number=(select count(*) from number where id <=a.id) from Number a where exists(select 1 from deleted )
汗,还是有错 create trigger trig_del on Material for delete as update a set Number=(select count(*) from Material where id <=a.id) from Material a where exists(select 1 from deleted )
--如果直接在表中加这么个字段,中间断号后,不是很好处理。还不如直接在查询时,显示这个编号。如:
select number=(select count(1) from 表名 where id<=a.id),* from 表名 a
from delete
as update a set Number=(select count(*) from number where id<=a.id) from Number a
where exists(select 1 from deleted )
for delete
as update a set Number=(select count(*) from number where id <=a.id) from Number a
where exists(select 1 from deleted )
for delete
as update a set Number=(select count(*) from Material where id <=a.id) from Material a
where exists(select 1 from deleted )