a guest Sep 20th, 2019 99 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- DECLARE @SearchText Varchar(100)
- SET @SearchText = 'something'
- SELECT DISTINCT o.xtype, o.name
- FROM syscomments c
- INNER JOIN sysobjects o On c.id = o.id
- WHERE c.text like '%' + @SearchText + '%'
- ORDER BY o.xtype, o.name
RAW Paste Data