Results 1 to 10 of 10
  1. #1
    Join Date
    Jun 2007
    Posts
    12

    Unanswered: Find table and column name from data

    I need to find a table and column name from some given data. I know what data i want to edit, I just need to know where it is located and the database is too big to manually go through. It is Microsoft sql server 2000. Any help is appreciated.

  2. #2
    Join Date
    Dec 2002
    Location
    Sunny Florida
    Posts
    121
    I don't understand your question.

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Is this what you're trying to say?
    I want to search my entire database for one piece of information and return the table and column name where the data is?
    George
    Home | Blog

  4. #4
    Join Date
    Jun 2007
    Posts
    12
    Yes that is what i am trying to say. I know how to write the replace code, I cant find where the data is located.

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    problemss, the data you want is in the verpflugten table in the geschnitten column

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    blindman has posted code for this but I can't find the link....

    Perhaps he will come along later and repost it.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  8. #8
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313

  9. #9
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by Brett Kaiser
    Same idea... different author

    It was defo blindman because I PMed him some optimisations ...which he ignored
    Testimonial:
    pootle flump
    ur codings are working excelent.

  10. #10
    Join Date
    Jun 2007
    Posts
    12
    Thank you guys so much, that was it. I really appreciate all your help. I am going to be bookmarking those links. Thank you again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •