SELECT sm.object_id, OBJECT_NAME(sm.object_id) AS object_name, o.type, o.type_desc, sm.definitionFROM sys.sql_modules AS smJOIN sys.objects AS o ON sm.object_id = o.object_idwhere sm.definition like ‘%要匹配的内容%‘ --collate SQL_Latin1_General_CP1_CI_ASORDER BY o.type;GOselect OBJECT_NAME(id) AS object_name,textfrom syscommentswhere text like ‘%要匹配的内容%‘-- Declare the text we want to search forDECLARE @Text nvarchar(4000);SET @Text = ‘要匹配的内容‘;-- Get the schema name, table name, and table type for:-- Table namesSELECT       TABLE_SCHEMA  AS ‘Object Schema‘      ,TABLE_NAME    AS ‘Object Name‘      ,TABLE_TYPE    AS ‘Object Type‘      ,‘Table Name‘  AS ‘TEXT Location‘FROM  INFORMATION_SCHEMA.TABLESWHERE TABLE_NAME LIKE ‘%‘+@Text+‘%‘UNION --Column namesSELECT      TABLE_SCHEMA   AS ‘Object Schema‘      ,COLUMN_NAME   AS ‘Object Name‘      ,‘COLUMN‘      AS ‘Object Type‘      ,‘Column Name‘ AS ‘TEXT Location‘FROM  INFORMATION_SCHEMA.COLUMNSWHERE COLUMN_NAME LIKE ‘%‘+@Text+‘%‘UNION-- Function or procedure bodiesSELECT      SPECIFIC_SCHEMA     AS ‘Object Schema‘      ,ROUTINE_NAME       AS ‘Object Name‘      ,ROUTINE_TYPE       AS ‘Object Type‘      ,ROUTINE_DEFINITION AS ‘TEXT Location‘FROM  INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE ‘%‘+@Text+‘%‘      AND (ROUTINE_TYPE = ‘function‘ OR ROUTINE_TYPE = ‘procedure‘);