菜鸟的两个问题—存储过程

[lzuyh]

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;

[qqjj7758]

你调用它遇到什么问题了吗?

[qqjj7758]

存储过程的好处是提交 SQL 在服务器 里运行 减少了交互过程和传输量
你的存储过程实现出现了什么问题没？

[lzuyh]

是问题太简单？？？？