SQL server2008 insert row times error: Invalid value for cell

Source: Internet
Author: User

In SQL server2008, you want to insert a record in the Student information table, but it is always unsuccessful, as follows:

At first I always thought it was the data type inconsistency, so I checked the seventh property of the T_userinfo table many times, that is, the Department property, and never found anything. Later on the online search, found that many people have encountered similar problems, but there is no suitable solution. In their own tinkering for a long time, decided to consult others, in fact, some things to ask others do not have to waste that person for many hours, there is no need for that person to help you solve the problem. Consult the main purpose is to allow their brains to inject new blood, there is a new way of thinking, whether right or wrong is not important, like rice teacher said 16-dimensional space, I need only in their own point of view can not go on, with the small partners exchange a different angle.

In the process of discussion found that I suddenly thought of the relationship between the table, most Baidu know that the questioner is only for a table of questions, but the problem appears in many of the related issues of the table. In the computer room charge system, student information table t_studentinfo and Cardid field is a foreign key, is associated with the card information table T_cardinfo primary key, because Cardid can not be empty, so before you add the Student information table, the record in the card information.

Then there is a small detail that deletes half of the incomplete information in the student's information before adding the card information sheet record. If you can't, you can first press ESC to cancel typing, then delete, and then add card information and student information at once.

I believe that many great gods have solved this problem, but no one has shared it, and it may be that my search is imperfect and I share my experience.

SQL server2008 insert row times error: Invalid value for cell

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.