If you're willing to jump through a load of hoops, you can update both tables with a view

CREATE TABLE ABC (Id INT NOT NULL , Name VARCHAR(10), Tab CHAR(1) NOT NULL DEFAULT('A') CHECK (Tab='A'), PRIMARY KEY(Id,Tab))

INSERT INTO ABC(Id,Name) VALUES (1, 'PK'), (2, 'SK')

CREATE TABLE ABC1 (Id INT NOT NULL, Name VARCHAR(10), Tab CHAR(1) NOT NULL DEFAULT('B') CHECK (Tab='B'), PRIMARY KEY(Id,Tab) )

INSERT INTO ABC1(Id,Name) VALUES (1, 'KKKKK'), (2, 'MMMMM')

GO

CREATE VIEW myView AS

SELECT Tab,Id,Name

FROM ABC

UNION ALL

SELECT Tab,Id,Name

FROM ABC1

GO

SELECT Id,Name FROM ABC

SELECT Id,Name FROM ABC1

UPDATE myView

SET Name = 'PPPPP'

WHERE Id=1

SELECT Id,Name FROM ABC

SELECT Id,Name FROM ABC1

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537