菜鸟的两个问题—存储过程
lzuyh 2003-10-16 10:01:39 1、我的数据量很大,在关闭程序时,执行下面语句的时候很慢,是不是用存储过程可以加快速度???
delete from table1 where ltrim(name)='';
delete from table2 where ltrim(name)='';
delete from table3 where ltrim(name)='';
delete from table4 where ltrim(name)='';
commit;
2、没用过存储过程,就见得做了一个,那位大哥帮忙看一看。方法是否正确。
create procedure pro_deldata
AS
begin
delete from table1 where ltrim(name)=''
delete from table2 where ltrim(name)=''
delete from table3 where ltrim(name)=''
delete from table4 where ltrim(name)=''
end;
pb调用如下:
declare pro_deldata_use procedure for pro_deldata
using sqlca;
execute pro_deldata_use;
if sqlca.sqlcode <> 0 then
messagebox("错误","错误信息:"+ sqlca.SQLErrText)
return
end if
close pro_deldata_use;