Oops..wrong group..sorry
From: [email protected] [mailto:[email protected]] On Behalf Of Anthony Sent: Wednesday, 4 May 2011 12:16 PM To: 'ozDotNet' Subject: Non Standard Column Names 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'.
