复制SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON SET ANSI_WARNINGS ON SET XACT_ABORT ON declare @ServerName varchar(50),据库计规介@UserName varchar(20),@Password varchar(20),@DBName varchar(30), @TableQuery varchar(4000)--参数定义 select @ServerName=vcComputer,@UserName=vcUserName,@Password=vcPassword,@DBName=vcDataBase from smDataParam set @TableQuery=select * into ##QJGroupInfo from opendatasource(+SQLOLEDB,+Data Source=+rtrim(@ServerName)+;User ID=+rtrim(@UserName)+;Password= +rtrim(@Password)+).+rtrim(@DBName)+.dbo.QJGroupInfo --将数据导到当前连接服务器的全局临时表中备用，
免费源码下载以后只要操作##QJGroupInfo表就可以 exec (@TableQuery) update smDept set vcDeptName=t.GroupName from ( select m.vcTransDeptNo,范简
g.GroupName from ##QJGroupInfo g inner join smDeptRelate m on m.vcSourceDeptNo=g.GroupID where m.RelateKind=0)as t where cDeptNo=t.vcTransDeptNo 1.2.3.4.5.6.7.8.9.10.11.12.13.
香港云服务器