alter TRIGGER [dbo].[trgTest] ON dbo.vwTest INSTEAD OF UPDATE
AS
BEGIN
SET NOCOUNT ON
--I cannot chnage field names..yes...very bad field names!
UPDATE Debt
SET [Print Filecover?]=Ins.[Print Filecover?]
FROM Debt
INNER JOIN inserted AS Ins ON Debt.[Test ID] = Ins.[Test ID]
END
Anyone explain why i get error Invalid column name 'Test ID'.
