SQL 数据库跨库连接代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】 SQL 数据库跨库连接

作者:Dezai.CN / 发布于2012/11/6/ 614

<div><span style="color: rgb(51, 51, 51); font-family: Arial; font-size: 14px; line-height: 26px;">--Open</span></div>
<p style="color: rgb(51, 51, 51); font-family: Arial; font-size: 14px; line-height: 26px;">exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
GO
declare @TUser table
(
[UserId] [int],
[UserName] [varchar](50),
[User_Password] [varchar](50),
[Firm] [varchar](50),
[Email] [varchar](50),
[LastLogin] [datetime],
[DefaultRole] [int]
)
<p style="color: rgb(51, 51, 51); font-family: Arial; font-size: 14px; line-height: 26px;">insert @TUser
select * from OPENDATASOURCE(
 'SQLOLEDB',
 'Data Source=192.168.168.113;User ID=sa;Password=sa'
 ).ProductionMgr.dbo.D_User
<p style="color: rgb(51, 51, 51); font-family: Arial; font-size: 14px; line-height: 26px;">
<p style="color: rgb(51, 51, 51); font-family: Arial; font-size: 14px; line-height: 26px;">declare @TGroupInfo table
(
[Grpid] [int],
[GroupName] [varchar](50)
)
insert into @TGroupInfo
<p style="color: rgb(51, 51, 51); font-family: Arial; font-size: 14px; line-height: 26px;">select * from OPENDATASOURCE(
 'SQLOLEDB',
 'Data Source=192.168.168.116;User ID=sa;Password=sa'
 ).ProductionMgr.dbo.GroupInfo
<p style="color: rgb(51, 51, 51); font-family: Arial; font-size: 14px; line-height: 26px;">
<p style="color: rgb(51, 51, 51); font-family: Arial; font-size: 14px; line-height: 26px;">declare @TUserAndGroup table
(
[UserId] [int],
[GrpId] [int]
)
insert into @TUserAndGroup
<p style="color: rgb(51, 51, 51); font-family: Arial; font-size: 14px; line-height: 26px;">select * from OPENDATASOURCE(
 'SQLOLEDB',
 'Data Source=192.168.168.113;User ID=sa;Password=sa'
 ).ProductionMgr.dbo.UserAndGroup
<p style="color: rgb(51, 51, 51); font-family: Arial; font-size: 14px; line-height: 26px;">select * from @TUser as u
inner join @TUserAndGroup as uag
on u.UserId=uag.UserId
inner join @TGroupInfo as g
on g.GrpId=uag.GrpId
<p style="color: rgb(51, 51, 51); font-family: Arial; font-size: 14px; line-height: 26px;">--close
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure
GO

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　跨库连接　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)