Professional Web Applications Themes

Select data from linked server - Microsoft SQL / MS SQL Server

Hi, i just set up a Linked Server in Enterprise Manager, and wonder how can I select data from a table in the database? The linked server I named MES, the database is LV2 and the table is "MyTable". How do I select all records from MyTable ? Regards, Bent *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...

  1. #1

    Default Select data from linked server

    Hi,

    i just set up a Linked Server in Enterprise Manager, and wonder how can
    I select data from a table in the database?

    The linked server I named MES, the database is LV2 and the table is
    "MyTable".


    How do I select all records from MyTable ?



    Regards,

    Bent

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Bent Guest

  2. #2

    Default Re: Select data from linked server

    You can use the OPENQUERY function like so:
    SELECT * FROM OPENQUERY (yourLinkedServerName, 'SELECT .... FROM yourTable')
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    http://www32.brinkster.com/srisamp

    "Bent Lund" <no> wrote in message
    news:%phx.gbl... 


    SriSamp Guest

  3. #3

    Default Select data from linked server

    Check this out

    SELECT * FROM MES.LV2.TableOwnername.MyTable


     
    wonder how can 
    the table is 
    *** 
    Arun[Symbiosis] Guest

Similar Threads

  1. Passing data from linked component?
    By limitedwave777 in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: May 28th, 02:19 PM
  2. Select data From 3 Linked Tables
    By StylusDesigns in forum Macromedia ColdFusion
    Replies: 12
    Last Post: June 8th, 02:48 AM
  3. Subform data select on access/ sql server database
    By Justin Levett-Yeats in forum Microsoft Access
    Replies: 0
    Last Post: July 21st, 05:46 PM
  4. Entering Data and then having another linked data show up.
    By Jennifer Van Pelt in forum Microsoft Access
    Replies: 2
    Last Post: July 16th, 06:15 PM
  5. Replies: 0
    Last Post: July 2nd, 06:18 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139