谢谢各位,现在问题是改了中文名以后不能用如下语句创建触发器
create trigger deltri on 采购
For Delete
AS
update 采购 set id=id-(select count(*) from deleted)
where id>=(select top 1 id from deleted)
提示对象'采购'无效,具体请看
http://expert.csdn.net/Expert/topic/2594/2594877.xml?temp=8.787173E-02
到时一起结帖