Post reply

Get the current ID for an Identity field

  • June 10, 2009 at 12:56 pm

    #73923

    Hi guys,

    Is there any other way to find the current Id in Identity field,instead of using IDENT_CURRENT?

  • June 10, 2009 at 12:58 pm

    #1007635

    You've posted this to a SQL Server 2000 forum so you'll be limited to SCOPE_IDENTITY(). If this were SQL Server 2005 or up, you could (and should due to a bug w/ SCOPE_IDNETITY()) use the OUTPUT clause.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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