有两个表
table1: systems
字段
systemid english korean chinse
table2: users
字段
systemid userid passwd usernm如何同时更新两个表的systemid ='0001'的所有字段??
table1: systems
字段
systemid english korean chinse
table2: users
字段
systemid userid passwd usernm如何同时更新两个表的systemid ='0001'的所有字段??
create procedure my_proc
as
begin
update tb1 ... where ...
update tb2 ... where ...
end