sql-server-2008 - 无法将值 NULL 插入到列 '' 中，表列不允许空值。 INSERT 失败。无法执行以下 SQL block

Question

当我执行以下命令时出现以下错误。有人可以帮忙吗!

Cannot insert the value NULL into column '', table column does not allow nulls. INSERT fails.Failed to execute following SQL block

BEGIN
    Select @v_setting_val=setting_val from EGPL_PROGRAM where setting_id=@v_setting_id
    and group_id =
        (select group_id
        from egpl_pref_group
        where group_type = 'departmental'
        and department_id=@v_department_id)

    INSERT INTO EGPL_PROGRAM
    (GROUP_ID, SETTING_ID, SETTING_VAL, IS_PREFERENCE, MODIFIER_ID, MODIFIED_DATE)
    VALUES
    (@v_group_id, @v_setting_id, @v_setting_val,'n',1,getdate());

    PRINT('Inserted the following value for group ' + convert(nvarchar, @v_group_id ))
    PRINT('Setting_id : ' + convert(nvarchar, @v_setting_id) + ' setting_val : ' + @v_setting_val)
END

Answer 1

检查表中不允许空值的列

这些列之一的值为空，或者您根本没有传递该列。
如果您有一个不在列列表中的不为空的列，则插入将以这种方式失败。