Home Forums SQL Server 2008 T-SQL (SS2K8) How to insert multiple rows into a table with identity column RE: How to insert multiple rows into a table with identity column

  • Solution:

    1) Set IDENTITY_INSERT to ON.

    2) Insert customers data into Customer table.

    3) Set IDENTITY_INSERT to OFF.

    Read full article here.