如果AID 为自增 declare @I int isnert into A (Aname) values(@Aname)set @I = scope_identity();insert into B (BID,BImage,Aid) values (@BID,@Bimage,@I)如不是自增 isnert into A (AID,Aname) values(@AID,@Aname)insert into B (BID,BImage,Aid) values (@BID,@Bimage,@AID)
增加一列去增加一个ID就可以了declare @n int set @n=0 update a set @n=@n+1 , ID=@nupdate b set @n=@n+1 , ID=@n
declare @aname varchar(100) declare @step intif not exists (select 1 from a where aname = @aname and step > @step) begin insert into a ... insert into b ... end
如果AID 为自增 declare @I int isnert into A (Aname) values(@Aname)set @I = scope_identity();insert into B (BID,BImage,Aid) values (@BID,@Bimage,@I) 如果@BID自增?
先查找数据库中的step取到最大的step作为判断条件。教我如何向这两个表中插入数据就行了,step就不考虑了
放到一个显示事务里
declare @I int
isnert into A (Aname)
values(@Aname)set @I = scope_identity();insert into B (BID,BImage,Aid)
values (@BID,@Bimage,@I)如不是自增
isnert into A (AID,Aname)
values(@AID,@Aname)insert into B (BID,BImage,Aid)
values (@BID,@Bimage,@AID)
set @n=0
update a
set @n=@n+1 , ID=@nupdate b
set @n=@n+1 , ID=@n
declare @aname varchar(100)
declare @step intif not exists (select 1 from a where aname = @aname and step > @step)
begin
insert into a ...
insert into b ...
end
declare @I int
isnert into A (Aname)
values(@Aname)set @I = scope_identity();insert into B (BID,BImage,Aid)
values (@BID,@Bimage,@I)
如果@BID自增?