Alter Store Proc所以我可以添加参数 [英] Alter Store Proc So I can add paramter

问题描述

您好，



请为我提供快速解决方案...........



我正在使用SQL Server数据库为数据库有超过100个存储过程的应用程序现在我需要在所有存储过程中添加一个参数。



我想要一个SqlServer查询，我不想一个接一个地去。



请尽快提供。紧急。



谢谢

解决方案

我不确定你打算做的行为的目的。即使您设法将参数添加到任何存储过程，您也需要在存储过程执行的某种逻辑中使用该参数，并且由于所有SP将具有不同的功能，因此您必须手动执行此操作！ />


但是，考虑到你在做你打算做的事情后有一些有效和深思熟虑的推理，试着按照

http://stackoverflow.com/questions/4367184/sql-script -to-change-all-table-references-in-all-stored-procedures [ ^ ]



这应该服务于目的。但请注意解决方案提供商提供的警告。



希望有所帮助



Milind

Hello,

Please provide me a quick solution ...........

I am using SQL Server Database for a application in which a database has more then 100 store procedure now I need to add one parameter into all the store procedure.

I want a SqlServer Query, I don''t want to go one by one.

Please provide ASAP.Its urgent.

Thanks

解决方案

I am not sure the purpose of the act that you intend to do. Even if you manage to add a parameter to any stored procedure, you need to use that parameter in some kind of logic being carried out by the Stored Procedure and since all SP will have different functionality, you will HAVE to do that manually !

But, considering you have some valid and well-thought reasoning behind doing what you intend to do, try to follow
http://stackoverflow.com/questions/4367184/sql-script-to-change-all-table-references-in-all-stored-procedures[^]

This should serve the purpose. But do pay attention to warnings given by Solution providers there.

Hope that helps

Milind

这篇关于Alter Store Proc所以我可以添加参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！