CREATE VIEW MYVIEW
AS
SELECT * FROM bjxxdiweb_database2007.dbo.bm_tongji
UNION ALL
SELECT * FROM aa.DBO.chen
select * into aa..chen from bjxxdiweb_database2007.dbo.bm_tongji where 1=2
说明:数据库A的表的字段名必须和数据库B的表的字段名相同,包括数据类型等。
CREATE VIEW MYVIEW
AS
SELECT * FROM bjxxdiweb_database2007.dbo.bm_tongji
UNION ALL
SELECT * FROM aa.DBO.chen
select * into aa..chen from bjxxdiweb_database2007.dbo.bm_tongji where 1=2
说明:数据库A的表的字段名必须和数据库B的表的字段名相同,包括数据类型等。