MS SQL 2008 R2触发器 [英] MS SQL 2008 R2 Triggers

问题描述

我是新来的触发器，我想问一下父表更新后如何自动更新子表.

我这里有表区域和表主列表

Hi,

I''m new to trigger, I would just like to ask how can I update the child table automatically when the parent table is updated.

I have here table area and table masterlist

--Area:
CREATE TABLE [dbo].[Area](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Area] [varchar](50) NOT NULL,
 CONSTRAINT [PK_Area_1] PRIMARY KEY CLUSTERED 

--MasterList:
CREATE TABLE [dbo].[MasterList](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[FullName] [varchar](50) NOT NULL,
	[Area] [varchar](50) NOT NULL,
	[MeterNumber] [varchar](20) NOT NULL,
	[MeterType] [varchar](20) NOT NULL,
 CONSTRAINT [PK_MasterList_1] PRIMARY KEY CLUSTERED 

它们都具有相同的Area Area.

我想问的是，如果我更新了Table Area.Area，我想自动更新MasterList.Area.

非常感谢你.高度赞赏您的建议:)

they both have the same field Area.

What I would like to ask is, If I updated the Table Area.Area I would like to automatically update the MasterList.Area.

Thank you very much. Your suggestion is highly appreciated :)

推荐答案

触发器看起来很新，在这里开始编写触发器是 Google [

Looks very new to triggers, Start your self to write a trigger here is the Link[^] where you can get some basic idea about the triggers with examples.

Here is the Google[^] Search for you to learn more about the Triggers

Thanks
--RA

这篇关于MS SQL 2008 R2触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！