
create view 视图名 as
(select xm as name,xb as sex,sfzh as id_card from database1student union all select name,sexid_card from database2teacher
)
查询的时候
select from 视图名 where xm='汪XX'
执行以下命令即可
exec sp_configure 'show advanced options',1reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)