ALTER SP在运行时 [英] ALTER SP WHILE running

问题描述

大家好.我有一个问题.

如果我在运行时尝试更改存储过程会发生什么

有可能吗?
在此先感谢





谢谢大家
我给了你5
来自墨西哥的问候

Hi Guys. i have a question.

what happend if i try to ALTER a Store Procedure while this is Running

it is possible?
thanks in advance





Thanks guys
I gave you 5
Regards from Mexico

推荐答案

在程序不再使用之前基本上什么也没有.之后，实际执行ALTER命令并更改过程.

是的，即使此过程当前正在使用中，您也可以发出ALTER语句.

Well basically nothing until the procedure is not in use anymore. After that the ALTER command is actually carried out and the procedure is changed.

Yes, you can issue the ALTER statement even if the procedure is in use at the moment.

是的，新的调用将转到已更改的过程，并且当前执行的过程将继续使用旧的过程版本.

Yes, new calls will go to the changed procedure and the current executing procedure will continue as the older version.

这篇关于ALTER SP在运行时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！