Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about how to use SQL statements in SQL Server to query a stored procedure that has been stored by all others. The article is rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

Use SQL statements in SQL Server to query the name of a stored procedure referenced by all other stored procedures

In the development of a project, if you sometimes modify a stored procedure, but how to quickly find the use of this storage

What about the other stored procedures of the procedure?

This issue is particularly important for slightly larger projects, where there are hundreds of stored procedures.

Can not be found one by one, even if they know a lot about the business and systems, for a long time, it is inevitable to remember.

How to use SQL statements to query?

Let's share with you the methods of SQL query:

Select distinct name

From syscomments a,sysobjects b

Where a.id=b.id and b.xtypewriter pro_GetSN%' p' and text like'%

The blue font section above represents the name of the stored procedure to query.

The above is the editor for you to share how to use SQL statements in SQL Server query a stored procedure has been all other stored, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.