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