[MSSQL]跨数据库访问数据表

opendatasource('sqloledb',   'data source=DATABAK  ;UID=sa;pwd=).数据库.dbo.表名

跨数据库访问数据表:

Create Procedure KqToDeptPersonMday As begin   --人事离职处理 更新人员表   declare @PersonNo as int,@Name as nvarchar(10),@duty as nvarchar(10)   --拷贝人事系统的离职人员表到临时表#templz   select cast(工号 as int) as 工号,姓名,直间接 into #templz from opendatasource('sqloledb',   'data source=DATABAK  ;UID=sa;pwd=).gwidb.dbo.out_TANXUEMEISYSTEMpawf   --拷贝人事系统的在职人员表到临时表#tempzz   select cast(工号 as int) as 工号,姓名,直间接 into #tempzz from opendatasource('sqloledb',   'data source=DATABAK  ;UID=sa;pwd=).gwidb.dbo.out_TANXUEMEISYSTEMpawf

  declare Cursorpawf cursor   local static for select * from #templz   Open Cursorpawf   while 1=1   begin   fetch Cursorpawf into           @PersonNo          ,@Name