Home Forums SQL Server 2008 SQL Server 2008 - General HOW TO FIND A VALUE IN ALL COLUMN OF ALL TABLE IN A db. RE: HOW TO FIND A VALUE IN ALL COLUMN OF ALL TABLE IN A db.

  • January 9, 2012 at 1:10 am

    #1430297

    Ivan Mohapatra (1/9/2012)

    HI ALL,

    As i Have a task to find 9 digit value in all column of all table in a DB or All DB in SQL server 2005.

    SO DO ANY ONE HAVE THE T-SQL STATEMENT TO FIND IT?

    All Help is appreciated.

    You'll need to use dynamic SQL to query for the character columns, then in a cursor loop through those columns looking for the correct values.