Professional Web Applications Themes

Retrieve last identity from a table - Microsoft SQL / MS SQL Server

Hi guys, know this is a pretty basic question, how do i retrieve the identity of a record after just having inserted a new record to a table? Thanks...

  1. #1

    Default Retrieve last identity from a table

    Hi guys,

    know this is a pretty basic question, how do i retrieve the identity of a
    record after just having inserted a new record to a table?

    Thanks



    Paul Guest

  2. #2

    Default Re: Retrieve last identity from a table

    Hi Paul,

    Use the SCOPE_IDENTITY() function on SQL Server 2000, or IDENTITY on
    earlier versions.

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


    "Paul" <co.za> wrote in message
    news:phx.gbl... 


    Jacco Guest

  3. #3

    Default Re: Retrieve last identity from a table

    You can use the SCOPE_IDENTITY() function.
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    http://www32.brinkster.com/srisamp

    "Paul" <co.za> wrote in message
    news:phx.gbl... 


    SriSamp Guest

Similar Threads

  1. Retrieve IDENTITY on CFQUERY
    By mikeap in forum Coldfusion Database Access
    Replies: 3
    Last Post: August 8th, 08:36 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