Post reply

Trigger

  • May 28, 2008 at 2:23 am

    #187179

    Hi,

    I have a table Empl with the the following fields

    TableName:Empl

    EmpId

    Name

    Salary

    I have same fields with the other table name as EmpDup

    TableName:EmpDup

    EmpId

    Name

    Salary

    When I delete the row in the Empl the deleted row should be inserted in to EmpDup using trigger. can some one help me

  • May 28, 2008 at 2:36 am

    #821023

    CREATE TRIGGER EmplDeleteTrigger

    ON Empl

    AFTER DELETE

    AS

    BEGIN

    INSERT INTO EmpDup (@EmpID, @Name, @Salary )

    END

    GO

    Basit Ali Farooq
    MCITP Database Administrator
    Microsoft Certified Professional Developer (Web Applications)
    Microsoft Certified Database Administrator
    Microsoft Certified Systems Engineer
    Microsoft Certified Systems Administrator
    CIW Security Analyst
    Cisco Certified Network Associate

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply