declare @name sysname, @id int
declare @sname sysname,@xtype int
declare @sql varchar(1000) , @b_data varchar(1000), @a_data varchar(10)
set @b_data = ‘http://’
DECLARE MYCUR CURSOR FOR
select name,id from dbo.sysobjects where xtype=’U’
OPEN MYCUR
FETCH NEXT FROM MYCUR INTO @name, @id
WHILE (@@FETCH_STATUS = 0)
BEGIN
DECLARE subcur CURSOR FOR
select name,xtype from dbo.syscolumns
where xtype in (
167 — varchar
,175 — char
,231 –nvarchar
,239 –nchar
)
and id=@id
OPEN subcur
FETCH NEXT FROM subcur INTO @sname,@xtype
WHILE (@@FETCH_STATUS = 0)
BEGIN
set @sql = ‘select * from dbo.’+@name+’ where ‘+ @sname + ‘ like ”%’+ @b_data +’%”’
exec (@sql)
FETCH NEXT FROM subcur INTO @sname,@xtype
END
CLOSE subcur
DEALLOCATE subcur
FETCH NEXT FROM MYCUR INTO @name, @id
END
CLOSE MYCUR
DEALLOCATE MYCUR