SQL 表定时同步

1.创建存储过程

   

create proc [dbo].[sync_calendar]
as
truncate table dbo.CalendarEvents
insert into CalendarEvents (title,startdate,enddate,type,year,createdate,updatedate ) 
select title,startdate,enddate,type,year,createdate,updatedate 
from  calendar.RSCalendar.dbo.CalendarEvents

2.SQL代理新增作业

posted @ 2017-10-11 15:30  百变小樱007  阅读(483)  评论(0)  编辑  收藏  举报