Shulou(Shulou.com)06/01 Report--

SQLServer inserts data into a table with a self-incrementing column and reports an error:

Explicit values can be specified for identity columns in table 'Sales.dbo.Area' only if column lists are used and IDENTITY_INSERT is ON.

The correct way:

Set IDENTITY_INSERT Sales.dbo.Area ON insert into Sales.dbo.Area ([SysNo], [DistrictSysNo], [DistrictName]) select [SysNo], [DistrictSysNo]

[DistrictName]

From opsdb.dbo.Area

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.