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 10:47 am

    #1430683

    Dev (1/9/2012)

    Agree with Sean. It’s not like regular requirements that we get from management. For instance, if a table has 2 rows and one of the columns have 123456789 and 12345678 values. Would you consider this table and column as desired output?

    What do you mean by wrong data type? Oversized columns? Don’t have data model of your database to figure it out? It would be a nice option, if you have.

    hope it is you ( DEV PINAL) I Am a great Fan Of Your SKill.

    yes I would consider that as desired out put.Because we don't have such data So As ID column has 9 digit only in my entire DB.