例如一个存储过程执行下面语句,ID是主键,
因为第三条会报错,所以我想将前两条插入table1
处理错误数据,将第三条插入table2
table1和table2表结构一样,如何实现?
insert into table1
select 1 as id,'Alex' as name,33.6 as total from dual
union all
select 2 as id,'Alex' as name,33.6 as total from dual
union all
select 1 as id,'Alex' as name,33.6 as total from dual
(这只是一个例子,主要意思是存储过程能加载进正确数据且不中断,把错误数据抛弃或者捕获到其他表里)
还有在Oracle中如果能实现,那么在Sql server中要怎么实现?
也希望指点一下,谢谢!!!