马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
数据库名: UFDATA_002_1999
C:\U8SOFT\Admin\SQLFILE12500\Main\Ufdata\data\NL\data_data_crm_initmk_nl.sql
错误信息:
-2147217873
违反了 PRIMARY KEY 约束 'PK_TC_TYPE'。不能在对象 'dbo.tc_type' 中插入重复键。
执行如下语句时出错:
----DATE 10月19
----预制部门销售计划 业务员销售计划
if not exists(select * from tc_type where obj_type =222)
BEGIN
INSERT INTO tc_type (obj_type,type_id,type_code,type_name,type_intro,arap_flag,create_enable,delivered_close_flag,payed_close_flag,finish_ahead_flag,finish_past_flag,disp_order,stop_flag,identify_code,server_flag,ext_fld,audit_flow_id,bDefault,u8_type_id,u8type,bSample) values(N'222',N'101',N'001',N'周部门销售目标',N'周部门销售目标',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'',N'',N'',N'0',N'',N'',N'',N'');
INSERT INTO tc_type (obj_type,type_id,type_code,type_name,type_intro,arap_flag,create_enable,delivered_close_flag,payed_close_flag,finish_ahead_flag,finish_past_flag,disp_order,stop_flag,identify_code,server_flag,ext_fld,audit_flow_id,bDefault,u8_type_id,u8type,bSample) values(N'222',N'102',N'002',N'周业务员销售目标',N'周业务员销售目标',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'',N'',N'',N'0',N'',N'',N'',N'');
INSERT INTO tc_type (obj_type,type_id,type_code,type_name,type_intro,arap_flag,create_enable,delivered_close_flag,payed_close_flag,finish_ahead_flag,finish_past_flag,disp_order,stop_flag,identify_code,server_flag,ext_fld,audit_flow_id,bDefault,u8_type_id,u8type,bSample) values(N'222',N'103',N'003',N'月部门销售目标',N'月部门销售目标',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'',N'',N'',N'0',N'',N'',N'',N'');
INSERT INTO tc_type (obj_type,type_id,type_code,type_name,type_intro,arap_flag,create_enable,delivered_close_flag,payed_close_flag,finish_ahead_flag,finish_past_flag,disp_order,stop_flag,identify_code,server_flag,ext_fld,audit_flow_id,bDefault,u8_type_id,u8type,bSample) values(N'222',N'104',N'004',N'月业务员销售目标',N'月业务员销售目标',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'',N'',N'',N'0',N'',N'',N'',N'');
INSERT INTO tc_type (obj_type,type_id,type_code,type_name,type_intro,arap_flag,create_enable,delivered_close_flag,payed_close_flag,finish_ahead_flag,finish_past_flag,disp_order,stop_flag,identify_code,server_flag,ext_fld,audit_flow_id,bDefault,u8_type_id,u8type,bSample) values(N'222',N'105',N'005',N'季部门销售目标',N'季部门销售目标',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'',N'',N'',N'0',N'',N'',N'',N'');
INSERT INTO tc_type (obj_type,type_id,type_code,type_name,type_intro,arap_flag,create_enable,delivered_close_flag,payed_close_flag,finish_ahead_flag,finish_past_flag,disp_order,stop_flag,identify_code,server_flag,ext_fld,audit_flow_id,bDefault,u8_type_id,u8type,bSample) values(N'222',N'106',N'006',N'季业务员销售目标',N'季业务员销售目标',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'',N'',N'',N'0',N'',N'',N'',N'');
END
|