how to find last recordid

• dastagirid

  SSCommitted

  Points: 1810

  More actions

  August 8, 2009 at 3:12 am

  #132605

  hi....

  I have a table primary key column with autoincrement..

  i have inserted somerecords and deleted all.How to find the

  last insertid record value .

  Thanks
  Dastagiri.D

• arun.sas

  SSChampion

  Points: 11831

  More actions

  August 8, 2009 at 4:08 am

  #1036395

  Repeated post, discussion already started,

  Link: http://www.sqlservercentral.com/Forums/Topic767384-338-1.aspx