set @m_tbname=''''declare #tb cursor for select name from ''''+@tbname+''''..sysobjects where xtype=''''''''U''''''''''''
exec(@m_tbname)
open #tb
fetch next from #tb into @m_tbname
while @@fetch_status=0
begin
set @sql=''''bcp ''''+@tbname+''''..''''+@m_tbname
+case when @isout=1 then '''' out '''' else '''' in '''' end
+'''' "''''+@filename+@m_tbname+''''.txt " /w''''
+'''' /S ''''+@servername
+case when isnull(@username,'''''''')='''''''' then '''''''' else '''' /U ''''+@username end
+'''' /P ''''+isnull(@password,'''''''')
exec master..xp_cmdshell @sql
fetch next from #tb into @m_tbname
end
close #tb
deallocate #tb
end
go

/************* Oracle **************/
EXEC sp_addlinkedserver ''''OracleSvr'''',
''''Oracle 7.3'''',
''''MSDAORA'''',
''''ORCLDB''''
GO

delete from openquery(mailser,''''select * from yulin'''')

select * from openquery(mailser,''''select * from yulin'''')

update openquery(mailser,''''select * from yulin where id=15'''')set disorder=555,catago=888

insert into openquery(mailser,''''select disorder,catago from yulin'''')values(333,777)

补充：

对于用bcp导出,是没有字段名的.

用openrowset导出,需要事先建好表.

用openrowset导入,除ACCESS及EXCEL外,均不支持非本机数据导入

上一页  [1] [2]