CREATE VIEW dbo.VUser
AS
SELECT id, username, CompanyID, Branchid, status, logintime, logouttime, VisitCount,
nickname, UserIP,last_msg_id
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=你的服务器的ip;User ID=用户名;Password=密码'
).msn.dbo.users
跨服务器查询
最新推荐文章于 2024-10-20 19:55:46 发布