34,594
社区成员
发帖
与我相关
我的任务
分享
create table t1
(
ID varchar(20)
)
insert into t1 select 'aaa'
insert into t1 select 'bbb'
create table t2
(
ID varchar(20)
)
insert into t2 select 'ccc'
insert into t2 select 'ddd'
alter proc proc_insert
(
@Q1 varchar(20),
@Q2 varchar(20)
)
as
if exists(select * from t1 where ID=@Q1)
begin
return 1
end
else
begin
insert into t1 select @Q1
if @@error<>0
return 2
insert into t2 select @Q2
if @@error<>0
return 2
else
return 0
end
exec proc_insert 'aaa','cccccccc'
select * from t1
ID
--------------------
aaa
bbb
exec proc_insert 'aaabbbb','cccccccc'
select * from t1
ID
--------------------
aaa
bbb
aaabbbb
select * from t2
ID
--------------------
ccc
ddd
cccccccc
create table MyPro(@Q1 int,@Q2 int)
as
begin
if exists(select top 1 1 from table1 where ID=@Q1)
return 1
insert into table1(ID) values(@Q1)
if @@ERROR>0
return 2
insert into table2(ID) values(@Q2)
if @@ERROR>0
return 2
return 0
end