CREATE FUNCTION [dbo].[Search]
(
@str VARCHAR(100)
)
RETURNS TABLE
RETURN
SELECT
DISTINCT s.name AS SchemaName,
o.name AS ObjectName,
o.type_desc AS ObjectType
FROM sys.objects o
INNER JOIN syscomments c ON c.Id = o.object_id
INNER JOIN sys.schemas s ON s.schema_id = o.schema_id
WHERE
is_ms_shipped = 0 AND c.text like '%' + @str + '%'
No comments:
Post a Comment