How to change data in first table, column FirstName, data = Joe,
This is my trigger:
ALTER TRIGGER trg_YourTrigger ON dbo.Table1 FOR UPDATE AS UPDATE B.dbo.Table2 SET ColumnY = I.ColumnX FROM inserted I INNER JOIN deleted D ON I.ID = D.ID WHERE B.dbo.BB.ColumnY = D.ColumnX
The first table I want to change the FirstName and writes this:
No row was updated
The data in row1 was not committed Error Source: .Net SqlClient Data Provider. Error Message: Invalid object name 'B.dbo.Table2.
trigger
Posted - 11/01/2010 : 17:05:49
