27,580
社区成员
发帖
与我相关
我的任务
分享
create database link yourdblinkname connect to yourusername identified by yourpassword using '(description=(address=(PROTOCOL=tcp)(HOST=10.25.10.159)(PORT=1528))(connect_data = (sid = yoursid)))';
insert into table table_b( field_list )
select field_list from table_a@yourdblinkname
drop database link yourdblinkname
if object_id('InsertInToWebServerData') is not null
drop proc InsertInToWebServerData
go
create procedure InsertInToWebServerData
@thedate varchar(10) --需要加入内容的时间,一般是用做比较的,格式:2009-06-30
as
declare @colname varchar(4000),@sql varchar(4000)
set @colname=''
set @sql=''
select @colname=@colname+name+',' from syscolumns where id=object_id('FileCollection') order by colorder
set @colname= substring(@colname,len('AutoID,,'),len(@colname)-len('AutoID,')-1) --查找出不包括AutoID在内的字段
--以下是插入数据到网站服务器数据库中
set @sql='insert into openrowset(''SQLOLEDB'',''59.53.xx.xxx '';''用户名'';''用户密码'',数据库名.dbo.表名)( ' + @colname+ ' ) select ' + @colname + ' from 本地表名 where convert(varchar(10),CreateDate,120)='''+@thedate+''''
exec (@sql)