如何更改列数据类型时如何减少对存储过程的影响？ [英] How to reduce the impact on Stored Procedures, when a column datatype is changed?

问题描述

我有一个数字数据类型的AccNo，因此AccNo中的前面的零被抑制。我想将数据类型更改为Varchar，但此列更改会对近50个存储过程产生影响。有没有办法用NO / Less对存储过程的影响来解决这个问题。

I have an AccNo of numeric datatype, because of which the preceding zeroes in AccNo gets suppressed. I want to change the datatype to Varchar, but this column change has an impact on nearly 50 stored procedures. Is there any way to solve this with NO/Less impact on stored procedures.

推荐答案

你做不到。所有存储过程都将重新编译，甚至可能会有一些存储过程无法完成...

You can't. All the stored procedures will recompile, and even possible that some of them will fail to do so...

这篇关于如何更改列数据类型时如何减少对存储过程的影响？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！