存储过程里同时有好几个动态sql执行时prepare s1 from v_sql;
execute s1;
....
prepare s2 from v_sql;
execute s2;
...
其中有个prepare,execute 语句还在一个循环里请问可以全部就用
prepare s from v_sql;
execute s;
吗?
execute s1;
....
prepare s2 from v_sql;
execute s2;
...
其中有个prepare,execute 语句还在一个循环里请问可以全部就用
prepare s from v_sql;
execute s;
吗?
prepare s1 from @v_sql;
execute s1;
DEALLOCATE PREPARE s1;
....