要连接一下另一台服务器,像平时跨数据库一样写,三个月前用函数
select cast(year(getdate()) as varchar)+'-'+cast(month(getdate())-3 as varchar)+'-'+cast(day(getdate()) as varchar)
select cast(year(getdate()) as varchar)+'-'+cast(month(getdate())-3 as varchar)+'-'+cast(day(getdate()) as varchar)
INSERT B..CAMX SELECT a,b,c,……(字段列表) FROM A..CAMX WHERE DATEDIFF(DAY,GETDATE(),s_rq)<=-90
DELETE A..CAMX WHERE DATEDIFF(DAY,GETDATE(),s_rq)<=-90
现在 自己执行的 作业也写好了, 谢谢大家的!!!!