无法插入表格的某些列 [英] Not able to insert into certain columns of the table

问题描述

我正在尝试将数据插入到我的表的某些列中，并且我一直收到以下错误消息。

I am trying to insert data into certain columns of my table and i keep getting the below error message.

Cannot insert the value NULL into column 'RKEY', table 'Test-Live.dbo.tempWIPAeroV1'; column does not allow nulls. INSERT fails.

我甚至不想在RKEY专栏中输入任何内容



我尝试过：

I am not even trying to enter anything in the RKEY column

What I have tried:

<pre> Insert into tempWIPAeroV1 (WIPMATL,WIP_sold) (select Material_cost ,Sold_cost  from NewValues  join tempWIPAeroV1 on  tempWIPAeroV1.RKEY = NewValues.RKEY )

推荐答案

表中的RKey列不允许使用NULL值。

当您插入新记录时不提供此字段的值，数据库将值设置为NULL。



因此您有3个选项;

a）编辑接受NULL值的字段如下

1）打开SQL企业管理器

2）右键单击表&选择设计

3）滚动到列&勾选Allow Nulls字段

4）关闭表格 - 提示保存时单击是

b）设置字段的默认值

1 ）打开SQL企业管理器

2）右键单击表&选择设计

3）选择正确的列

4）根据字段类型设置默认值或Binding字段

5）关闭table - 提示保存时单击Yes

c）更新您的Insert语句如下（仅示例）

The column RKey in your table does not allow a NULL value.
When you insert a new record & do not provide a value for this field, the database will set the value to NULL.

Therefore you have 3 options;
a) Edit the field to accept a NULL value as follows
1) Open SQL Enterprise Manager
2) Right-click the Table & select Design
3) Scroll to the column & tick the Allow Nulls field
4) Close the table - click Yes when prompted to save
b) Set a Default value for the field
1) Open SQL Enterprise Manager
2) Right-click the Table & select Design
3) Select the correct column
4) Set the Default value or Binding field based on the field type
5) Close the table - click Yes when prompted to save
c) Update your Insert statement as below (example only)

Insert into tempWIPAeroV1 (WIPMATL,WIP_sold, RKey) (select Material_cost ,Sold_cost, RKEY  from NewValues  join tempWIPAeroV1 on  tempWIPAeroV1.RKEY = NewValues.RKEY )

亲切的问候

Kind Regards

INSERT INTO tempWIPAeroV1 (WIPMATL,WIP_sold, RKey)
                (SELECT Material_cost ,Sold_cost,ISNULL(tempWIPAeroV1.RKEY,'') AS RKey  
                 FROM NewValues
                 LEFT JOIN tempWIPAeroV1 ON  (tempWIPAeroV1.RKEY = NewValues.RKEY) );

这篇关于无法插入表格的某些列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！