Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Identity column value should not be increased if there's pbm in insertion of record. RE: Identity column value should not be increased if there's pbm in insertion of record.

  • November 4, 2008 at 5:29 am

    #893549

    If you already have a primary key then what is the need for the Identity column?

    if is for display purposes only , you could use ROW_NUMBER() and generate a sequence number when you run a query