CREATE PROCEDURE AddAppendItem
@UniqueGUID char(44),
@columns_1 char(50),
@columns_2 char(50),
@columns_3 char(50),
@columns_4 char(50),
@columns_5 char(50),
@columns_6 char(50),
@columns_7 char(50),
@columns_8 char(50),
@columns_9 char(50),
@columns_10 char(50)
AS
select * from T_Append where UniqueGUID = @UniqueGUID;
if @@ROWCOUNT > 0
begin
declare @ret int
exec @ret=UpdateAppendItem @UniqueGUID, @columns_1,@columns_2,@columns_3,@columns_4,@columns_5,
@columns_6,@columns_7,@columns_8, @columns_9, @columns_10
return @ret;
end
else
begin
insert into T_Append values (@UniqueGUID, @columns_1,@columns_2,@columns_3,@columns_4,@columns_5,
@columns_6,@columns_7,@columns_8, @columns_9, @columns_10 )
if @@ROWCOUNT = 0 and @@ERROR != 0 return -1;
if @@ROWCOUNT = 1 and @@ERROR= 0 return 0;
end;
GO
CREATE PROCEDURE UpdateAppendItem
@UniqueGUID char(44),
@columns_1 char(50),
@columns_2 char(50),
@columns_3 char(50),
@columns_4 char(50),
@columns_5 char(50),
@columns_6 char(50),
@columns_7 char(50),
@columns_8 char(50),
@columns_9 char(50),
@columns_10 char(50)
AS
if @columns_1 <> '' update T_Append set columns_1 = @columns_1 where uniqueGUID = @UniqueGUID;
if @columns_2 <> '' update T_Append set columns_2 = @columns_2 where uniqueGUID = @UniqueGUID;
if @columns_3 <> '' update T_Append set columns_3 = @columns_3 where uniqueGUID = @UniqueGUID;
if @columns_4 <> '' update T_Append set columns_4 = @columns_4 where uniqueGUID = @UniqueGUID;
if @columns_5 <> '' update T_Append set columns_5 = @columns_5 where uniqueGUID = @UniqueGUID;
if @columns_6 <> '' update T_Append set columns_6 = @columns_6 where uniqueGUID = @UniqueGUID;
if @columns_7 <> '' update T_Append set columns_7 = @columns_7 where uniqueGUID = @UniqueGUID;
if @columns_8 <> '' update T_Append set columns_8 = @columns_8 where uniqueGUID = @UniqueGUID;
if @columns_9<> '' update T_Append set columns_9 = @columns_9 where uniqueGUID = @UniqueGUID;
if @columns_10 <> '' update T_Append set columns_10 = @columns_10 where uniqueGUID = @UniqueGUID;
if @@ERROR != 0 return -1 --update failed!
return 0
转换Oracle脚本!!!!在线急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急等!
@UniqueGUID char(44),
@columns_1 char(50),
@columns_2 char(50),
@columns_3 char(50),
@columns_4 char(50),
@columns_5 char(50),
@columns_6 char(50),
@columns_7 char(50),
@columns_8 char(50),
@columns_9 char(50),
@columns_10 char(50)
AS
select * from T_Append where UniqueGUID = @UniqueGUID;
if @@ROWCOUNT > 0
begin
declare @ret int
exec @ret=UpdateAppendItem @UniqueGUID, @columns_1,@columns_2,@columns_3,@columns_4,@columns_5,
@columns_6,@columns_7,@columns_8, @columns_9, @columns_10
return @ret;
end
else
begin
insert into T_Append values (@UniqueGUID, @columns_1,@columns_2,@columns_3,@columns_4,@columns_5,
@columns_6,@columns_7,@columns_8, @columns_9, @columns_10 )
if @@ROWCOUNT = 0 and @@ERROR != 0 return -1;
if @@ROWCOUNT = 1 and @@ERROR= 0 return 0;
end;
GO
CREATE PROCEDURE UpdateAppendItem
@UniqueGUID char(44),
@columns_1 char(50),
@columns_2 char(50),
@columns_3 char(50),
@columns_4 char(50),
@columns_5 char(50),
@columns_6 char(50),
@columns_7 char(50),
@columns_8 char(50),
@columns_9 char(50),
@columns_10 char(50)
AS
if @columns_1 <> '' update T_Append set columns_1 = @columns_1 where uniqueGUID = @UniqueGUID;
if @columns_2 <> '' update T_Append set columns_2 = @columns_2 where uniqueGUID = @UniqueGUID;
if @columns_3 <> '' update T_Append set columns_3 = @columns_3 where uniqueGUID = @UniqueGUID;
if @columns_4 <> '' update T_Append set columns_4 = @columns_4 where uniqueGUID = @UniqueGUID;
if @columns_5 <> '' update T_Append set columns_5 = @columns_5 where uniqueGUID = @UniqueGUID;
if @columns_6 <> '' update T_Append set columns_6 = @columns_6 where uniqueGUID = @UniqueGUID;
if @columns_7 <> '' update T_Append set columns_7 = @columns_7 where uniqueGUID = @UniqueGUID;
if @columns_8 <> '' update T_Append set columns_8 = @columns_8 where uniqueGUID = @UniqueGUID;
if @columns_9<> '' update T_Append set columns_9 = @columns_9 where uniqueGUID = @UniqueGUID;
if @columns_10 <> '' update T_Append set columns_10 = @columns_10 where uniqueGUID = @UniqueGUID;
if @@ERROR != 0 return -1 --update failed!
return 0
转换Oracle脚本!!!!在线急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急等!
解决方案 »
- 关于SELECT USERNAME FROM TABLE_USER WHERE USER_ID IN(1,2,3,4);
- 一台电脑一个端口可以开两个oracle数据库服务?
- oralce 日期问题
- xmltype的长度最多是多少 在线等!!!!
- 请问ORACLE中多久后会自动解锁???(急:100分!)
- ★为什么用户名和口令都对,但就是不能登录到oracle呢?
- [求助]关于建立序列的问题
- 用过创智医保程序的请进!
- 高分请教关于在使用javamail实现在oracle里发送邮件附件的功能!
- oracle pdb创建用户之后如何使用sql developer登陆
- 跨用户查询
- 请高手指点,为什么我的dbms_job执行不成功?
再现急等!!!!!!!!!!!!!!!!!!!