locked
Table name , Column name from Data value RRS feed

  • Question

  • Hi,

       I have 3 tables namely  T1 with column A,B,C and T2 with columns  D,E ,T3 with columns E,F .  A data namely 100 is present in any of the column . Need to find out the column name and Table name where that data exists . Please advice .

    Regards

    Selvaraj

    Tuesday, November 2, 2010 10:02 AM

Answers

  • Hello,

    Please, could you tell us from where your 3 tables are coming ? ( a dataset, SQL Server database,Access...)

    If you are searching in a SQL Server database, please, could you give informations about your SQL Server ( Version : 2000,2005,2008,2008 R2 ) ?

    I am sorry, but i am fearing that the question is too general and , for the moment, it is very difficult to help you.

    We are waiting for your feedback to try to help you more efficiently

    Have a nice day

    PS : please, could you have a look here ?

    http://social.msdn.microsoft.com/forums/en-us/transactsql/thread/F7DFDE1D-A3F6-4C99-AD58-33F77B010B30

    Maybe, you find the solution or at least a way to solve your problem


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    • Edited by Papy Normand Tuesday, November 2, 2010 5:04 PM Post-scriptum added
    • Marked as answer by KJian_ Monday, November 8, 2010 6:21 AM
    Tuesday, November 2, 2010 5:02 PM