SQL Complete No Longer Shows Column List For Trigger Tables
I could've sworn SQL Complete used to show the column names for the inserted/deleted tables in the list members
CREATE TRIGGER [dbo].[tu_Contact_StandingId]
ON [dbo].[Contact]
AFTER UPDATE
AS
BEGIN
IF UPDATE(StandingId)
BEGIN
INSERT CapitaTransaction (CapitaTransactionId, CapitaPackageId, ContactId, CapitaTransactionTypeId, OldStandingId, OldStandingDate,
NewStandingId, NewStandingDate, IsReport, SectionCodeId, CreatedBy, CreatedById, CreatedOn, ModifiedBy, ModifiedById, ModifiedOn)
SELECT NEWID(), NULL, d.
FROM DELETED d
JOIN INSERTED i ON d.ContactId = i.ContactId
WHERE ISNULL(d.StandingId, -1) <> ISNULL(i.StandingId, -1);
END
END;
GO
ALTER TABLE [dbo].[Contact] ENABLE TRIGGER [tu_Contact_StandingId]
GO