When you import data in SQL Server, there is an option to "Enable labeled insertion", and suddenly it's crazy, what does that mean? I choose and do not choose this option, the results seem to be no different! Unscientific ah this, "existence is reasonable", I believe this option must have its usefulness, but I do not know it.
So I went to check the information and found a possible explanation in the CSDN forum:
1) First: Enable marker insertion only works on the labeled column (the column defined by the identity). So if you want to use this feature, there must be a list of labels. The thing I was dizzy about was that I didn't create the table in the database, but instead created the table directly in the process of importing the data, and the default SQL statement that created the table would not define the column; So, if you're lazy, add the marker column to the Edit SQL statement button. If you import data as a non-identity column, it doesn't make sense to enable and not enable identity column insertion.
2) Second: If it is an indicator column, you select "Enable marking Insert" to identify the column is not automatically generated, but instead use the imported columns in the external file (such as excel,txt, etc.), and if you do not select "Enable marking Insert", the identity column is automatically generated.
Forum Link: http://bbs.csdn.net/wap/topics/390325583
"Enable label insertion" in SQL server when importing data