Trigger

• gouripatil23

  SSC Veteran

  Points: 224

  More actions

  January 11, 2008 at 4:40 am

  #71218

  Hi!

  I want Update one table when in another table insert new record .I didn't understand how i get this new inserted ID.

  Regards

  Gouri

• Andras Belokosztolszki

  SSC-Insane

  Points: 22031

  More actions

  January 11, 2008 at 4:55 am

  #767035

  gouripatil23 (1/11/2008)

  ---

  Hi!

  I want Update one table when in another table insert new record .I didn't understand how i get this new inserted ID.

  Regards

  Gouri

  Hi Gouri,

  In the trigger body you have access to two virtual tables, inserted and deleted. These contain the data about the rows that you have inserted (or deleted/modified). You can update the table you wish based on the inserted table. See http://msdn2.microsoft.com/en-us/library/ms189799.aspx

  Regards,

  Andras

  ---

  Andras Belokosztolszki, MCPD, PhD
  GoldenGate Software

• appala.naidu

  Grasshopper

  Points: 15

  More actions

  July 22, 2010 at 1:17 am

  #1196656

  The below code may help u in finding ur problem

  set ANSI_NULLS ON

  set QUOTED_IDENTIFIER ON

  GO

  -- =============================================

  -- Author:<Author,,Name>

  -- Create date: <Create Date,,>

  -- Description:<Description,,>

  -- =============================================

  ALTER TRIGGER [dbo].[Insert_Trg_Dept]

  ON [dbo].[Dept]

  AFTER INSERT

  AS

  BEGIN

  SET NOCOUNT ON;

  DECLARE

  @EMPID INT,

  @DEPTID INT,

  @DEPTNAME VARCHAR(50)

  SELECT @EMPID=EMPID FROM EMPLOYEE

  INSERT INTO DEPT VALUES(@DEPTNAME,@DEPTID,@EMPID)

  END