34,594
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE [dbo].[tb1](
[uid] [int] IDENTITY(1,1) NOT NULL,
[remark] [nvarchar](50) NULL,
CONSTRAINT [PK_tb1] PRIMARY KEY CLUSTERED
(
[uid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[tb2] Script Date: 2018/2/8 16:02:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb2](
[id] [int] IDENTITY(1,1) NOT NULL,
[uid] [int] NULL,
[remark] [nvarchar](50) NULL,
CONSTRAINT [PK_tb2] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[tb1] ON
GO
INSERT [dbo].[tb1] ([uid], [remark]) VALUES (1, N'测试1')
GO
INSERT [dbo].[tb1] ([uid], [remark]) VALUES (2, N'测试2')
GO
INSERT [dbo].[tb1] ([uid], [remark]) VALUES (3, N'测试333')
GO
SET IDENTITY_INSERT [dbo].[tb1] OFF
GO
SET IDENTITY_INSERT [dbo].[tb2] ON
GO
INSERT [dbo].[tb2] ([id], [uid], [remark]) VALUES (1, 1, N'测试1')
GO
INSERT [dbo].[tb2] ([id], [uid], [remark]) VALUES (2, 2, N'测试2')
GO
INSERT [dbo].[tb2] ([id], [uid], [remark]) VALUES (3, 3, N'测试3')
GO
SET IDENTITY_INSERT [dbo].[tb2] OFF
GO
CREATE TRIGGER UPDATE_B ON TB1
FOR UPDATE
AS
BEGIN
IF UPDATE(REMARK)
BEGIN
UPDATE TB2
SET REMARK=A.REMARK
FROM INSERTED A
JOIN TB2 B ON A.UID=B.UID
END
END
CREATE TRIGGER dbo.tb1_tri ON [dbo].tb1
FOR UPDATE
AS
BEGIN
UPDATE tb2
SET remark = Inserted.remark
FROM Inserted
WHERE Inserted.uid = tb2.uid
END
GO
UPDATE dbo.tb1 SET remark='aaaa' WHERE uid=1
SELECT * FROM tb1
SELECT * FROM tb2