17 May 2012

To find the text in the stored procedure in Sql server

To find the text in the stored procedure in Sql server



declare @newString varchar(205)
Set @newString = '%' + 'CNC_EmailResults_Other' + '%'
-- Insert statements for procedure here
select name from sysobjects where id in
(select id from syscomments where text like @newString)
order by name

No comments:

Post a Comment

Comments Welcome

Find number of letter occurence of all letter in c#

  Find number of letter occurence of all letter in c#  namespace ConsoleApp1 {     internal class Program     {         static void Main(st...