Only when the column list is used and identity_insert is on can an explicit value be specified for the ID column in The 't_articlefiles 'table.

When importing table data from another database to a database today, the system suddenly prompts "only when the column list is used and the identity_insert is on, you can specify an explicit value for the ID column in the table 't_ articlefiles." At the beginning, I thought I was wrong. Later I found that it was set identity_insert xdsdev. DBO. t_articlefiles on. If I inserted data into the data table, I could not write it directly.

Insert into t_articlefiles select * from XXX. DBO. t_articlefiles to insert data. You must write the data displayed in the t_articlefiles column. In the past, although we knew to directly insert data with auto-incrementing columns to a table with auto-incrementing columns, we had to set the identity_insert of this table to on, but it had never been used, today, I actually used it to know the correct way of writing it. It is indeed a glimpse of the end of the paper.