CREATE TRIGGER trgInsteadOfUpdate1 ON dbo.Domod
INSTEAD OF INSERT
AS
-- Insert into Region
UPDATE OEORDD
SET EXTINVMISC != 0
FROM OEORDD INNER JOIN
Domod ON OEORDD.ORDUNIQ = Domod.ORDUNIQ
GO
kindly tell da problem want to update a table from a view table dat i ve created
INSTEAD OF INSERT
AS
-- Insert into Region
UPDATE OEORDD
SET EXTINVMISC != 0
FROM OEORDD INNER JOIN
Domod ON OEORDD.ORDUNIQ = Domod.ORDUNIQ
GO
kindly tell da problem want to update a table from a view table dat i ve created