create trigger tri_tablename_insert on tablemname
instead of insert
as
insert tablename(ID,F1,F2,..) select (select count(*) from tablename)+1,F1,F2,.. from inserted
instead of insert
as
insert tablename(ID,F1,F2,..) select (select count(*) from tablename)+1,F1,F2,.. from inserted
也就是在外界增加数据,而字段又是主键.
试了,不行.
也就是在外界增加数据,而字段又是主键.
这个要求和你在触发器中做事矛盾的啊,你到底想用该字段来做什么用???