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

Recommended Answers

All 3 Replies

IIRC you can just use the column names.

Thankx inserted table helped.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.