Results 1 to 3 of 3

Thread: sql command

  1. #1
    Join Date
    Jun 2009
    Location
    Midlands
    Posts
    135

    Unanswered: sql command

    Hi all, how are you?

    I am trying to find a persons name from a database that has 200+ tables, does any body know if there is an SQL query that can search all tables for that persons name and return all info pertaining to this person?

    would it be something like this?

    SELECT *
    FROM sysobjetcs
    WHERE name like'% bob %'

    Hope you can help

    kind regards
    MG

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jun 2009
    Location
    Midlands
    Posts
    135
    Hi,

    That didnt make a lot of sense to be honest.

    Regards
    MG

Posting Permissions

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