Asta merge:
create table TEST_HIST(COL1 int PRIMARY KEY CHECK (col1 BETWEEN 1 AND 4), COL2 varchar(20), COL3 datetime)
create table TEST_LIVE(COL1 INT PRIMARY KEY CHECK (col1>4), COL2 varchar(20), COL3 datetime)
INSERT INTO TEST_HIST SELECT 1,'test 1', '2011-10-10 13:04:14.403'
INSERT INTO TEST_HIST SELECT 2,'test 2', '2011-10-11 13:04:14.403'
INSERT INTO TEST_HIST SELECT 3,'test 3', '2011-10-12 13:04:14.403'
INSERT INTO TEST_HIST SELECT 4,'test 4', '2011-10-13 13:04:14.403'
INSERT INTO TEST_LIVE SELECT 5,'test 5', '2011-10-15 13:04:14.403'
INSERT INTO TEST_LIVE SELECT 6,'test 6', '2011-10-16 13:04:14.403'
INSERT INTO TEST_LIVE SELECT 7,'test 7', '2011-10-17 13:04:14.403'
INSERT INTO TEST_LIVE SELECT 8,'test 8', '2011-10-18 13:04:14.403'
INSERT INTO TEST_LIVE SELECT 9,'test 9', '2011-10-19 13:04:14.403'
go
CREATE VIEW dbo.VW_TEST
AS
SELECT * FROM dbo.TEST_LIVE
UNION ALL
SELECT * FROM dbo.TEST_HIST
go
update a
SET a.COL2 ='test x'
from VW_TEST a where a.COL1 = 1
Vezi
Partitioned Views in MSDN.
Razvan