how to get last insert record id

• dastagirid

  SSCommitted

  Points: 1810

  More actions

  August 8, 2009 at 1:32 am

  #213234

  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 2:33 am

  #1036389

  SELECT IDENT_CURRENT('MYTABLE')