ALTER procedure [dbo].[GetSPFNNameContainText]
(
@text varchar(500)
)
as
select name, text
from sysobjects o, syscomments s
where o.id = s.id
and text like '%'+@text+'%'
and (o.xtype = 'P' or o.type='FN')
(
@text varchar(500)
)
as
select name, text
from sysobjects o, syscomments s
where o.id = s.id
and text like '%'+@text+'%'
and (o.xtype = 'P' or o.type='FN')