maxkoshevoi

DECLARE @SearchStr nvarchar(100) = 'TEXT_TO_SEARCH_FOR'

DECLARE @Results TABLE(ColumnName nvarchar(370), ColumnValue nvarchar(3630))

SET NOCOUNT ON

DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
SET  @TableName = ''
SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')

maxkoshevoi

SELECT      c.name  AS 'ColumnName'
            ,t.name AS 'TableName'
FROM        sys.columns c
JOIN        sys.tables  t   ON c.object_id = t.object_id
WHERE       c.name LIKE '%email%'
ORDER BY    TableName
            ,ColumnName;

maxkoshevoi

public bool DoWork(HtmlDocument document)
        {
            //Сбрасываем предыдущие результаты
            for (int i = 0; i < Pathways.Count; i++)
            {
                for (int j = 0; j < Pathways[i].elements.Count; j++)
                {
                    SetNull(Pathways[i].elements[j]);
                }
            }