Home Forums SQL Server 2008 SQL Server Newbies IDENTITY_INSERT, and Using Alphanumeric Autoincrement Primary Key RE: IDENTITY_INSERT, and Using Alphanumeric Autoincrement Primary Key

  • June 1, 2013 at 7:38 am

    #1620280

    Hi,

    As per my concern we can not apply identity property on alphanumeric field.

    to set the identity property on you have to use like this,

    SET IDENTITY_INSERT table_name ON/OFF

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/