如果主从表都是单一的数据,那么只需要调用存储就能实现了,
如:
CREATE PROCEDURE aaa
as
declare @AutoID int
inser into a(a)values('a')
set @AutoID=SCOPE_IDENTITY()
inser into b(AutoID,a)values(@AutoID,'b')
如果主从表都是单一的数据,那么只需要调用存储就能实现了,
如:
CREATE PROCEDURE aaa
as
declare @AutoID int
inser into a(a)values('a')
set @AutoID=SCOPE_IDENTITY()
inser into b(AutoID,a)values(@AutoID,'b')