问题描述

截图如下：

解决办法

SP_SET_PARA_VALUE(1,'MULTI_UPD_OPT_FLAG',2);

参数说明

整改后执行结果

演示示例SQL

create table ttest1(id int,name char(10));
alter table ttest1 add primary key(id);
insert into  ttest1 values(1,'');
create table ttest2(nid int,nname char(10));

alter table ttest2 add primary key(nid);
insert into  ttest2 values(1,'t2-1');

create view  tview(vid,vname) as select id,name from ttest1,ttest2 where ttest1.id=ttest2.nid;

select *  from tview;

update   tview set vname='uvtest0'  where vid=1;

insert into tview values(2,'t1-1');

delete tview where vid=1;