insert into MICS_WorkPlan_RestDays select * from OPENROWSET( ' SQLOLEDB ', ' SERVER=192.168.2.97;uid=用户名;pwd=密码;Database=数据库 ', ' select * from v_restdays(sql语句,可执行存储过程) ') as a