我要在新注册用户时,在另一个表中插入这个刚注册用户的ID,语句如上面如:table1 table2
注册的SQL语句
insert into table1(userName,pwd) values(name,password)触发器语句
create trigger insertID on table1 after insert
insert into table2( userID ) values ( @@identity )为什么上面语句做不了
谢谢
注册的SQL语句
insert into table1(userName,pwd) values(name,password)触发器语句
create trigger insertID on table1 after insert
insert into table2( userID ) values ( @@identity )为什么上面语句做不了
谢谢
create trigger insertID
on table1
for after insert
begin
as
insert into table2( userID ) values ( @@identity )
end