An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON SQL Server

by 
SET IDENTITY_INSERT tableA ON

You have to make a column list for your INSERT statement:

INSERT Into tableA ([id], [c2], [c3], [c4], [c5] ) 
SELECT [id], [c2], [c3], [c4], [c5] FROM tableB

not like “INSERT Into tableA SELECT ……..”

SET IDENTITY_INSERT tableA OFF

More Related Contents:

  1. SQL Server – error when creating stored procedure
  2. What do Clustered and Non-Clustered index actually mean?
  3. Regex pattern inside SQL Replace function?
  4. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  5. Add IIS 7 AppPool Identities as SQL Server Logons
  6. SQL Server: Query fast, but slow from procedure
  7. Errors: “INSERT EXEC statement cannot be nested.” and “Cannot use the ROLLBACK statement within an INSERT-EXEC statement.” How to solve this?
  8. Is there a way to loop through a table variable in TSQL without using a cursor?
  9. sql server invalid object name – but tables are listed in SSMS tables list
  10. How to get a date in YYYY-MM-DD format from a TSQL datetime field?
  11. How do I format a number with commas in T-SQL?
  12. What columns generally make good indexes?
  13. What is a free tool to compare two SQL Server Databases? [closed]
  14. How can I make HTTP request from SQL server?
  15. SQL Server Management Studio alternatives to browse/edit tables and run queries [closed]
  16. SQL Server: Database stuck in “Restoring” state
  17. Format SQL in SQL Server Management Studio
  18. Split one column into multiple rows
  19. #DELETE viewing SQL Server table in Access
  20. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  21. Grant Select on a view not base table when base table is in a different database
  22. SQL Server (localdb)\v11.0 explained
  23. How to store directory / hierarchy / tree structure in the database?
  24. SQL Server – join rows into comma separated list
  25. Which is quicker COALESCE OR ISNULL?
  26. Merge multiple rows into a single row
  27. Is there an “IF EXISTS” test for a linked server?
  28. Unique identifier (guid) as primary key in database design
  29. How to extract this specific substring in SQL Server?
  30. SQL Server stored procedure return code oddity

Leave a Comment