我不知道哪個sp中有12345這個字串,如何查詢出是哪個sp中包含這個字串呢

------
x

這對設計人員很重要, 語法如下, 不過自己寫的我會另編文字檔, 因為後端容易被人修改掉.

select distinct b.name, b.xtype, object_name(b.parent_obj) as parent_name
from syscomments a, sysobjects b
where a.text like '%查詢文字%' and b.id=a.id and b.status>=0 and
(b.xtype='P' or b.xtype='TR' or b.xtype='V' or b.xtype='FN')
order by b.xtype, object_name(b.parent_obj), b.name

其中
name: trigger, procedure, view, function name
xtype: TR = trigger, P = procedure, V = view, FN = function
parent_name: 表示 trigger 的 table name