Post reply

What does .. mean

  • August 17, 2004 at 4:21 am

    #163110

    Hi,

    When referencing a table, I have sometimes seen the use of a .. (double period). Can you tell me what this means?

    Thanks.

  • August 17, 2004 at 5:21 am

    #519294

    The .. means use the table that the user has access to owned by anyone which is implied.  Generally means dbo owner though in some shops it means owned by the user.

    The schema to reference an object is 4 parts:

     [Server].[Database].[Owner].[Object]

    Most of the time objects are referenced using 1 part [Object] only or 2 part [Owner].[Object].

    What you are seeing I think is 3 part [Database].[Owner].[Object] without EXPLICITLY stating who the owner of the object is i.e. pubs..authors.

    The bad thing is that the server tries to 1st find an object owned by the user and then looks for dbo owned.  IF you specify the owner i.e. pubs.dbo.authors the server can go direrctly to the table and do a little less round-robin.

    Hope this helps



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • August 17, 2004 at 5:40 am

    #519300

    That makes perfect sense in the context in which I have seen this kind of notation.

    Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply