我把几个Delete语句写在一个存储过程中 执行起来快不快?怎么写速度会快一点

[hhfh]

Create procedure sp_DeleteAll
@id int
As
Delete From tab1 where id=@id
Delete From tab2 where id=@id
Delete From tab3 where id=@id
go
我把几个Delete语句写在一个存储过程中 执行起来快不快?
怎么写速度会快一点

[zxbyhcsdn]

在一个存储过程中当然要快了哟!!

你也可以传三个Sql语句过去,一起执行

self.AdoQuery.Sql.text
:="Delete From tab1 where id=@id;Delete From tab2 where id=@id;Delete From tab3 where id=@id"

self.AdoQuery.exexusQl

[samfeng_2003]

好象只能这样写吧！其他没有什么好办法了！如果想优化，那么可能要从你建立索引上考虑了！

[vivianfdlpw]

好像没更好的方法，另外建议放在事务中

Create procedure sp_DeleteAll
@id int
As
set xact_abort on
begin tran
Delete From tab1 where id=@id
Delete From tab2 where id=@id
Delete From tab3 where id=@id
commit tran
go

[wgsasd311]

效果是一样的。

[iwl]

肯定会快一点