"Enable label insertion" in SQL server when importing data

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.