存储过程中包含某字符

select object_name(parent_obj) as TableName,name,status,crdate from sysobjects where xtype = 'TR' order by parent_obj

select distinct name from sysobjects o, syscomments s where o.id = s.id and (o.xtype = 'P' or o.xtype = 'FN' or o.xtype = 'TF' or o.xtype = 'TR' or o.xtype = 'V') and text like '%要查询的字符%'