0

I have a trigger on insert

    CREATE TRIGGER [dbo].[InsertNewCustomersAsGroupMembers]
    ON  [CustomerBase].[dbo].[Cutomers]
    AFTER INSERT
    AS 
    BEGIN

        SET NOCOUNT ON;

        -- Insert statements for trigger here
        DECLARE @inserterdCustomerID uniqueidentifier
        UPDATE [CustomerBase].[dbo].[GroupMembers]
        ?---?

    END
    GO

I want to get the values of the inserted record at [CustomerBase].[dbo].[customers] into the trigger inorder to update [CustomerBase].[dbo].[GroupMembers] table. How can i get them?

thank you in advance

3
Contributors
3
Replies
21
Views
4 Years
Discussion Span
Last Post by jrosh
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.