Fork me on GitHub

sql 根据表名查找存储过程 

SELECT obj.Name, sc.TEXT

FROM syscomments sc

INNER JOIN sysobjects obj ON sc.Id = obj.ID

WHERE sc.TEXT LIKE '%t_um_ob_curr_status%'

AND TYPE = 'P'

 

posted @ 2018-09-26 14:18  Mask1  阅读(1905)  评论(0)  编辑  收藏  举报