'' /U ''''+@username end +'''' /P ''''+isnull(@password,'''''''') exec master..xp_cmdshell @sql end else begin --导出整个数据库,定义游标,取出所有的用户表 declare @m_tbname varchar(250) if right(@filename,1)<>''''\'''' set @filename=@filename+''''\''''
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] [办公软件]在sybase中插入图片、PDF、文本文件 [办公软件]安装Sybase ASE [办公软件]linux指令大全(完整篇) [办公软件]Linux新手入门常用命令大全 [办公软件]在RedHat Linux 9里安装gaim0.80 [办公软件]浅谈Linux 下Java 1.5 汉字方块问题解决方法 [办公软件]Linux程序员必读:中文化与GB18030标准 [办公软件]linux指令大全 [办公软件]制作Linux启动盘的四种方法 [办公软件]Linux文件系统的反删除方法
|