declare @ta_1 int
declare @ta_2 int
declare @tb_id int
set @ta_1=456
set @ta_2=410
if exists (select 1 from table_A where ta_1=@ta_1 and ta_2=@ta_2)
begin
set @tb_id=(select tb_id from table_A where ta_1=@ta_1 and ta_2=@ta_2)
insert into table_B(tb_1,tb_2) values(@ta_1,@ta_2)
set @tb_id=@@identity
update table_A set tb_id=@tb_id where ta_1=@ta_1 and ta_2=@ta_2
end
else
print '没有此值!'
问题是:我们在table_A中查询ta_1和ta_2的值,如果有就录入table_B的值,并把
tb_id的值自动添入table_A中,如果没有就提示‘没有此值!’等字样。
----------------------------------------------------------------
declare @ta_1 int
declare @ta_2 int
declare @tb_id int
set @ta_1=456
set @ta_2=410
if exists (select 1 from table_A where ta_1=@ta_1 and ta_2=@ta_2)
begin
insert into table_B(tb_1,tb_2) values(@ta_1,@ta_2)
set @tb_id=scope_identity() --如此设计表tb_id应该是标识列
update table_A set tb_id=@tb_id where ta_1=@ta_1 and ta_2=@ta_2
end
else
print '没有此值!'
--加上table_a中tb_id的值.
ta_id ta_1 ta_2 tb_id
1 123 234 1
2 456 410 2
table_B中没有数据,但table_B表中的主键是表table_A的外键,
tb_id tb_1 tb_2
问题是:我们在table_A中查询ta_1和ta_2的值,如果有就录入table_B的值,并把
tb_id的值自动添入table_A中,如果没有就提示‘没有此值!’等字样。
------------------------------------------------------------------------------------
declare @ta_1 as int
declare @ta_2 as int
set @ta_1 = 123
set @ta_2 = 234
if exists (select * from table_a where ta_1 = @ta_1 and ta_2 = @ta_2)
insert into table_b select ta_1,ta_2,tb_id where ta_1 = @ta_1 and ta_2 = @ta_2
else
print '没有此值!'