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