CREATE VIEW Customers AS SELECT * FROM Customers_33 UNION SELECT * FROM Server2.CustomerDB.dbo.Customers_66 UNION SELECT * FROM Server3.CustomerDB.dbo.Customers_99
保证不重复,将union all 换成union就行了.这种视图当然是不可以更新的.因为无法确定你要更新的数据属于那一个表
我不知道產生這個問題的原因,假如樓上的是對的!那你應該創建一個觸發器在這個view上! create trigger tg_Custommers ON Customers instead of update as begin --每一個table 單獨Update的SQL end
CREATE VIEW Customers AS SELECT * FROM Customers_33 UNION ALL SELECT * FROM Server2.CustomerDB.dbo.Customers_66 UNION ALL SELECT * FROM Server3.CustomerDB.dbo.Customers_99这个视图我已用了UNION ALL连接 不知上面楼主邹建:"保证不重复"是什么意思?
AS
SELECT * FROM Customers_33
UNION
SELECT * FROM Server2.CustomerDB.dbo.Customers_66
UNION
SELECT * FROM Server3.CustomerDB.dbo.Customers_99
create trigger tg_Custommers ON Customers
instead of update
as
begin
--每一個table 單獨Update的SQL
end
AS
SELECT * FROM Customers_33
UNION ALL
SELECT * FROM Server2.CustomerDB.dbo.Customers_66
UNION ALL
SELECT * FROM Server3.CustomerDB.dbo.Customers_99这个视图我已用了UNION ALL连接
不知上面楼主邹建:"保证不重复"是什么意思?