Professional Web Applications Themes

multiuser safe IDENT_CURRENT(...) - Microsoft SQL / MS SQL Server

Hello! In the SQL Server doentation is said that it "returns the last identity value generated for a specified table in any session and any scope" To obtain unique numbers client makes one insert and than calls IDENT_CURRENT. So rises the question is it possible that 2 or more clients will get equal numbers? And if it is possible how to avoid such a thing....

  1. #1

    Default multiuser safe IDENT_CURRENT(...)

    Hello!

    In the SQL Server doentation is said that it "returns
    the last identity value generated for a specified table in
    any session and any scope"

    To obtain unique numbers client makes one insert and than
    calls IDENT_CURRENT.

    So rises the question is it possible that 2 or more
    clients will get equal numbers? And if it is possible how
    to avoid such a thing.


    Vadym Guest

  2. #2

    Default Re: multiuser safe IDENT_CURRENT(...)

    Hi Vadym,

    If you want to get the last Identity value generated for a user, you have to
    use SCOPE_IDENTITY() instead of
    IDENT_CURRENT. SCOPE_IDENTITY() is not influenced by what other users do on
    that table.

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "Vadym Stetsyak" <net> wrote in message
    news:02f601c35ccc$fefc0980$gbl... 


    Jacco Guest

  3. #3

    Default Re: multiuser safe IDENT_CURRENT(...)

    IDENT_CURRENT(...) takes table name as parameter and
    SCOPE_IDENTITY() doesn't get any parameter, so will unique
    identity be retuned if we insert to different tables.

    And another question: will SCOPE_IDENTITY() return unique
    identities in the database scope?
     
    a user, you have to 
    other users do on [/ref]
    in [/ref]
    than [/ref]
    how 
    >
    >
    >.
    >[/ref]
    Vadym Guest

  4. #4

    Default Re: multiuser safe IDENT_CURRENT(...)

    Thanks, Jacco
     
    (unless you have 
    value that's been 
    in an identity 
    in your procedure 
    local variable after [/ref]
    unique [/ref]
    unique [/ref][/ref]
    for [/ref][/ref]
    what [/ref][/ref]
    it "returns [/ref][/ref]
    table 
    >> than 
    >> how [/ref]
    >
    >
    >.
    >[/ref]
    Vadym Guest

Similar Threads

  1. Xtra MultiUser
    By :. Buzzalino \(Foros Macromedia\) .: in forum Macromedia Director Lingo
    Replies: 0
    Last Post: November 4th, 07:07 PM
  2. Multiuser
    By Jota Mix in forum Macromedia Director Lingo
    Replies: 0
    Last Post: September 9th, 10:01 PM
  3. Replies: 3
    Last Post: August 30th, 02:42 PM
  4. $SAFE = 5 and Safe Ruby Misleading?
    By kirindave@lensmen.net in forum Ruby
    Replies: 9
    Last Post: August 13th, 03:31 PM

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