不在同一个数据库，将a数据库中b表某个字段更改为b数据库中的c表某个字段的数据，前提是两个数据库表中的字段有相同的数据字段

USE [newscxzrs]
GO
/* Object: StoredProcedure [dbo].[settime] Script Date: 09/29/2017 13:14:13 */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
– select a.title,a.add_time from dt_article a

–创建一个游标数据表
create proc [dbo].[settime] as
–修改一个游标数据表
ALTER proc [dbo].[settime] as
begin
declare @title varchar(200)
declare @odate varchar(50)

–定义一个游标
declare user_cur cursor for select NewsTitle,CreateDate from rm.dbo.DX_News where DeleteMark = ‘1’
–打开游标
open user_cur
fetch next from user_cur into @title,@odate
while @@fetch_status=0
begin
–读取游标
update dt_article set add_time = @odate where ltrim(rtrim(title)) = ltrim(rtrim(@title));
fetch next from user_cur into @title,@odate
end
close user_cur
–摧毁游标
deallocate user_cur
end