If a stored procedure is modified during project development, how can I quickly find other stored procedures using the stored procedure?
If a stored procedure is modified during project development, how can I quickly find other stored procedures using the stored procedure?
This issue is especially important for projects with a relatively large scale. If there are hundreds of stored procedures in the database,
I can't find them one by one. Even if I understand the business and system very well, it will take a long time to remember.
How can I use SQL statements for queries?
The following describes how to query SQL statements:
The Code is as follows:
Select distinct name
From syscomments a, sysobjects B
Where a. id = B. id and B. xtype = 'p' and text like '% pro_GetSN %'
The blue font area above indicates the name of the stored procedure to be queried.
Author: weizhiai12