Software Wizards, Inc.

TIPS

Q:     Stored procedure to find text in sql database
 
A:      CREATE PROCEDURE [dbo].[FindTextInDatabase]
-- Add the parameters for the stored procedure here
@text varchar(200)

AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
declare @newString varchar(205)
Set @newString = '%' + @text + '%'
-- Insert statements for procedure here
select name from sysobjects where id in
(select id from syscomments where text like @newString)
order by name
END
Software Wizards, Inc. 1998-2009 | Site Map