Auto-increment column Error

I want to insert data from another table today, and the results have various problems.

This Baidu query: insert into B (ID, title, content) Select ID, title, content from

This is written at the beginning:
Insert into Table B select * from Table A (in this case, an error message is returned .)

Set identity_insert Table A on

Solution:
Set identity_insert Table A off
Set identity_insert table B off
The correct statement is as follows:
Insert into Table B (cardno, [Password], truename, sex, email, property, crops, plantingarea, usedrugs, remark, typestatus, tgid, telphone, userid, createtime, [address], province, city, area, culture)
Select cardno, [Password], truename, sex, email, property, crops, plantingarea, usedrugs, remark, typestatus, tgid, telphone, userid, createtime, [address], province, city, area, culture
From Table

Auto-increment column Error