27,579
社区成员
发帖
与我相关
我的任务
分享
create proc test
(
@id int
)
begin
insert into db2..b select bcid,name from db1..a where id=@id
end
USE DB1
GO
CREATE PROC PR_TEST
@ID INT
AS
DECLARE @BCID INT
INSERT DB2.DBO.B(NAME) SELECT NAME FROM A WHERE ID = @ID
SET @BCID = SCOPE_IDENTITY ()
UPDATE A
SET BCID = @BCID
WHERE ID = 1
GO
--调用
USE DB1
GO
EXEC PR_TEST 1
GO
USE DB2
GO
CREATE PROC PR_TEST
@ID INT
AS
DECLARE @BCID INT
INSERT B(NAME) SELECT NAME FROM DB1.DBO.A WHERE ID = @ID
SET @BCID = SCOPE_IDENTITY ()
UPDATE DB1.DBO.A
SET BCID = @BCID
WHERE ID = 1
GO
--调用
USE DB2
GO
EXEC PR_TEST 1
GO
USE DB2
DECLARE @BCID INT
INSERT B(NAME) SELECT NAME FROM DB1.DBO.A WHERE ID = 1
SET @BCID = SCOPE_IDENTITY ()
UPDATE DB1.DBO.A
SET BCID = @BCID
WHERE ID = 1
GO