sqlserver 跨库拷贝数据

Create Procedure up_InsertData2
@ID INT
AS
BEGIN
Declare @Name NVARCHAR(30)
Declare @c1 NVARCHAR(30)
Declare @c2 NVARCHAR(30)
Declare @c3 NVARCHAR(30)
Declare @c4 NVARCHAR(30)
Declare tmpCur Cursor For Select a,b,c,d from  table1
Open tmpCur;
Fetch Next from tmpCur Into @c1,@c2,@c3,@c4;
While @@Fetch_Status=0
Begin
insert into OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=127.0.0.1;User ID=sa;Password=sa'
         ).descx.dbo.table1(a,b,c,d) values(@c1,@c2,@c3,@c4);
Fetch Next from tmpCur Into  @c1,@c2,@c3,@c4;
End
Close tmpCur;
DealLocate tmpCur;
END
EXEC up_InsertData2 2