能,用存储过程吧.
begin
select ............
update ............
insert ............
delete ............
end;
也行.
begin
select ............
update ............
insert ............
delete ............
end;
也行.
begin
update A set A.B='XXX' where XXX;
delete from A where B='XXXX';
end;注意使用分割符;
select ............/
update ............/
insert ............/
delete ............/
SELECT B.a AS a,
B.b AS b,
B.c AS c,
B.d AS d,
B.e AS e,
1 AS f,
2 AS g,
'1'AS h
FROM TABLE_B .B
WHERE A.s = B. s
这样语法也能够实现。
一次执行,如果是一条一条执行,不需要问吧?
如果你指的是服务器并行执行所有SQL,那好象这样问又不能说清楚吧?