How can I view a stored procedure by using sp_HelpText
?
I am not sure about its exact spelling? I am looking for something like below,
EXEC sp_HelpText WHERE storedprocedurename Like '%spInsert%'
Is it possible way to view the stored procedure?
How can I view a stored procedure by using sp_HelpText
?
I am not sure about its exact spelling? I am looking for something like below,
EXEC sp_HelpText WHERE storedprocedurename Like '%spInsert%'
Is it possible way to view the stored procedure?
1条答案
按热度按时间2wnc66cl1#
Create below stored procedure in your database. It will helpful to you in future also.
It will provide all matched store procedure list, which contains/using given keyword.
TextSpName