Get the current ID for an Identity field

• arctica82

  Ten Centuries

  Points: 1013

  More actions

  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?

• John Rowan

  SSC Guru

  Points: 56440

  More actions

  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