SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Addict
    Join Date
    Aug 2004
    Location
    vi
    Posts
    207
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    how to link two database tables in sql server 2000

    How can you create a link between tables in different sql databases.

    What method can I use to create this link between tables in sql server databases.

    Example:

    Database 1> table> store::::::: Database 2> table> customer

    any links to help sites will work fine or any old topics. I am sure thisquestion has been asked several time sin the past.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,015
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    just qualify the table names in the query

    select ... from database1.owner1.store as S
    inner join database2.owner2.customer as C
    on S.store_id = C.store_id
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Member
    Join Date
    Feb 2005
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    is there any wizard to link tables in a database in sql server

  4. #4
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by gayathri2k3
    is there any wizard to link tables in a database in sql server
    No, just the wizard between your ears.

  5. #5
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    asterix
    No, just the wizard between your ears.
    very funny Asterix.

  6. #6
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    MS SQL actually has lots of wizards, all accessible through the enterprise manager. You have wizars for creating maintainence plans, doing performance traces, analyzing index usage, import and exporting data, scripting database objects etc. etc.

    If you really want wizards when working with Microsoft SQL Server data you could:

    Install MS Access 2003, then use access as the frontend to a MSSQL database. Then you get some wizards.

    But my point was: selecting data over two tables is hardly such a complicted task that one really needs wizards for it. And if you do, perhaps SQL Server is not the best tool for you? Access provides all kinds of help for non-expert users in the area of analyzing and retrieving data.


Bookmarks

Posting Permissions

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