How to Get Next Identity Value from Identity Column in SQL Server 2008

  1. Select IDENT_CURRENT('YourtableName')+IDENT_INCR('YourTablename'as NecxtPrimeryIdentityValue