Post reply

Search for String in all columns

  • November 7, 2012 at 1:25 am

    #270555

    Comments posted to this topic are about the item Search for String in all columns

    Wes
    (A solid design is always preferable to a creative workaround)

  • November 7, 2012 at 8:58 am

    #1556832

    This could prove very useful -- thank you 🙂

  • November 7, 2012 at 10:11 am

    #1556856

    Glad to hear it.

    I've already made a few minor revisions to it that I'll try to post a bit later when I have some time.

    Wes

    Wes
    (A solid design is always preferable to a creative workaround)

  • November 7, 2012 at 4:14 pm

    #1556969

    --*********************************

    --Show progress on the message tab

    --*********************************

    PRINT @sql

    PRINT 'Column ' + CAST(@LoopNo AS NVARCHAR(5)) + ': ' +@Schema + '.' + @Table + '.' + @Column + ' @ ' + CONVERT(VARCHAR(12),CURRENT_TIMESTAMP,114)

    When trying to backport the code to SQL 2005, I messed up the progress message, causing it to show the date instead of the time. Replace the progress block with the lines pasted above. This does not affect the functionality of the code in any way. I just found it useful to know the time and duration a table was searched.

    Sample message tab output:

    SELECT [TechnologyName] FROM [dim].[Technology] where charINDEX('Approved',[TechnologyName]) > 0

    Column 3: dim.Technology.TechnologyName @ 16:08:56:573

    The message tab includes the select statement used for the search so you can copy it and run it manually if you need to.

    Wes
    (A solid design is always preferable to a creative workaround)

  • May 5, 2016 at 7:10 am

    #1876824

    Thanks for the script.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply