📄 月光软件站 - 编程文档 - 数据库 - sql语句导入导出大全.htm
字号:
<BR> ,创建日期 varchar(10),创建时间 varchar(20) <BR> ,上次写操作日期
varchar(10),上次写操作时间 varchar(20) <BR> ,上次访问日期
varchar(10),上次访问时间 varchar(20),特性 int) <BR> insert into #tb
<BR> exec master..xp_getfiledetails @fname <BR> select
@fsize=大小 from #tb <BR> drop table #tb <BR> if @fsize is
null <BR> begin <BR> print ’文件未找到’ <BR> return
<BR> end </P>
<P>end </P>
<P>--生成数据处理应答文件 <BR>set @m_tbname=’[##temp’+cast(newid() as
varchar(40))+’]’ <BR>set @sql=’select * into <A
href="mailto:’+@m_tbname+’">’+@m_tbname+’</A> from( <BR> select
null as 类型 <BR> union all select 0 as 前缀 <BR> union all
select <A href="mailto:’+@fsize+’">’+@fsize+’</A> as 长度
<BR> union all select null as 结束 <BR> union all select
null as 格式 <BR> ) a’ <BR>exec(@sql) <BR>select
@fname_in=@fname+’_temp’ <BR> ,@sql=’bcp "<A
href="mailto:’+@m_tbname+’">’+@m_tbname+’</A>" out "<A
href="mailto:’+@fname_in">’+@fname_in</A> <BR> +’" /S"<A
href="mailto:’+@servename">’+@servename</A> <BR> +case when
isnull(@username,’’)=’’ then ’’ <BR> else ’" /U"<A
href="mailto:’+@username">’+@username</A> end <BR> +’"
/P"’+isnull(@password,’’)+’" /c’ <BR>exec master..xp_cmdshell @sql
<BR>--删除临时表 <BR>set @sql=’drop table <A
href="mailto:’+@m_tbname">’+@m_tbname</A> <BR>exec(@sql) </P>
<P>if @isout=1 <BR>begin <BR> set @sql=’bcp "select top 1 <A
href="mailto:’+@fdname+’">’+@fdname+’</A> from ’ <BR> <A
href="mailto:+@tbname+case">+@tbname+case</A> isnull(@tj,’’) when ’’
then ’’ <BR> else ’ where <A
href="mailto:’+@tj">’+@tj</A> end <BR> +’" queryout "<A
href="mailto:’+@fname">’+@fname</A> <BR> +’" /S"<A
href="mailto:’+@servename">’+@servename</A> <BR> +case when
isnull(@username,’’)=’’ then ’’ <BR> else ’" /U"<A
href="mailto:’+@username">’+@username</A> end <BR> +’"
/P"’+isnull(@password,’’) <BR> +’" /i"<A
href='mailto:’+@fname_in+’"’'>’+@fname_in+’"’</A> <BR> exec
master..xp_cmdshell @sql <BR>end <BR>else <BR>begin
<BR> --为数据导入准备临时表 <BR> set @sql=’select top 0 <A
href="mailto:’+@fdname+’">’+@fdname+’</A> into ’ <BR> <A
href="mailto:+@m_tbname+’">+@m_tbname+’</A> from ’ <A
href="mailto:+@tbname">+@tbname</A> <BR> exec(@sql) </P>
<P> --将数据导入到临时表 <BR> set @sql=’bcp "<A
href="mailto:’+@m_tbname+’">’+@m_tbname+’</A>" in "<A
href="mailto:’+@fname">’+@fname</A> <BR> +’" /S"<A
href="mailto:’+@servename">’+@servename</A> <BR> +case when
isnull(@username,’’)=’’ then ’’ <BR> else ’" /U"<A
href="mailto:’+@username">’+@username</A> end <BR> +’"
/P"’+isnull(@password,’’) <BR> +’" /i"<A
href='mailto:’+@fname_in+’"’'>’+@fname_in+’"’</A> <BR> exec
master..xp_cmdshell @sql <BR> <BR> --将数据导入到正式表中
<BR> set @sql=’update <A href="mailto:’+@tbname">’+@tbname</A>
<BR> +’ set <A
href="mailto:’+@fdname+’=b.’+@fdname">’+@fdname+’=b.’+@fdname</A>
<BR> +’ from <A href="mailto:’+@tbname+’">’+@tbname+’</A> a,’
<BR> <A href="mailto:+@m_tbname+’">+@m_tbname+’</A> b’
<BR> +case isnull(@tj,’’) when ’’ then ’’ <BR>
else ’ where <A href="mailto:’+@tj">’+@tj</A> end
<BR> exec(@sql) </P>
<P> --删除数据处理临时表 <BR> set @sql=’drop table <A
href="mailto:’+@m_tbname">’+@m_tbname</A> <BR>end </P>
<P>--删除数据处理应答文件 <BR>set @sql=’del <A
href="mailto:’+@fname_in">’+@fname_in</A> <BR>exec
master..xp_cmdshell @sql </P>
<P>go </P>
<P><BR>/** 导入文本文件 <BR>EXEC master..xp_cmdshell ’bcp
"dbname..tablename" in c:\DT.txt -c -Sservername -Usa -Ppassword’
</P>
<P>改为如下，不需引号 <BR>EXEC master..xp_cmdshell ’bcp dbname..tablename in
c:\DT.txt -c -Sservername -Usa -Ppassword’ </P>
<P>/** 导出文本文件 <BR>EXEC master..xp_cmdshell ’bcp "dbname..tablename"
out c:\DT.txt -c -Sservername -Usa -Ppassword’ <BR>此句需加引号
<BR></P><IMG height=1
src="月光软件站 - 编程文档 - 数据库 - SQL语句导入导出大全.files/down_info.htm" width=1
border=0><BR><BR></TD></TR>
<TR>
<TD width="100%" bgColor=#cccccc height=1></TD></TR>
<TR>
<TD width="100%"><BR><B>相关文章</B>：
<P><B>相关软件</B>：</P></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></CENTER></DIV>
<CENTER>
<SCRIPT src="月光软件站 - 编程文档 - 数据库 - SQL语句导入导出大全.files/bottom.js"
type=text/javascript></SCRIPT>
</CENTER>
<DIV id=objbottom align=center>
<CENTER>
<SCRIPT type=text/javascript>
var arrBaiduCproConfig=new Array();
arrBaiduCproConfig['uid'] =43125;
arrBaiduCproConfig['n'] ='williamlongcpr';
arrBaiduCproConfig['tm'] ='22';
arrBaiduCproConfig['cm'] ='72';
arrBaiduCproConfig['um'] ='22';
arrBaiduCproConfig['w'] ='728';
arrBaiduCproConfig['h'] ='90';
arrBaiduCproConfig['wn'] ='4';
arrBaiduCproConfig['hn'] ='1';
arrBaiduCproConfig['ta'] ='right';
arrBaiduCproConfig['tl'] ='bottom';
arrBaiduCproConfig['bu'] ='0';
arrBaiduCproConfig['bd'] ='#ffffff';
arrBaiduCproConfig['bg'] ='""';
arrBaiduCproConfig['tt'] ='#444444';
arrBaiduCproConfig['ct'] ='#000000';
arrBaiduCproConfig['url'] ='#000000';
arrBaiduCproConfig['bdl'] ='#ffffff';
arrBaiduCproConfig['rad'] =1;
</SCRIPT>
<SCRIPT src="月光软件站 - 编程文档 - 数据库 - SQL语句导入导出大全.files/ui.js" type=text/javascript
charset=gbk>
</SCRIPT>
<SCRIPT type=text/javascript>
<!--
document.write(baiduCproIFrame());
-->
</SCRIPT>
</CENTER></DIV>
<SCRIPT language=javascript>
if(document.all.item("objtop") != null)
{
objtop.innerHTML = objbottom.innerHTML
}
</SCRIPT>
<BR><BR><BR>
<DIV align=center>
<CENTER>
<TABLE style="FONT-SIZE: 9pt" cellSpacing=0 cellPadding=1 width=770 border=0>
<TBODY>
<TR>
<TD width=770 bgColor=#000000 height=1></TD></TR>
<TR>
<TD width=770 height=5></TD></TR>
<TR>
<TD align=middle width=770><A href="http://www.moon-soft.com/"
target=_top>月光软件</A>┊<A href="http://www.moon-soft.com/download/"
target=_top>程序下载</A>┊<A href="http://www.moon-soft.com/doc/"
target=_top>编程文档</A>┊<A href="http://www.moon-soft.com/book/"
target=_top>电脑教程</A>┊<A href="http://www.moon-soft.com/web/"
target=_top>网站设计</A>┊<A href="http://www.moon-soft.com/site/"
target=_top>网址导航</A>┊<A href="http://www.moon-soft.com/art/"
target=_top>网络文学</A>┊<A href="http://www.moon-soft.com/game/"
target=_top>游戏天地</A>┊<A href="http://www.moon-soft.com/joke/"
target=_top>幽默笑话</A>┊<A href="http://www.moon-soft.com/life/"
target=_top>生活休闲</A>┊<A href="http://www.moon-soft.com/picture/"
target=_top>美女图片</A>┊<A href="http://www.moon-soft.com/guestbook/"
target=_top>意见反馈</A><BR><A
href="http://www.moon-soft.com/program/bbs/docelite1105.htm">电脑技术</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite405353.htm">编程开发</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite25188.htm">网络专区</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite10811.htm">谈天说地</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite113108.htm">情感世界</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite872697.htm">游戏元素</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite50820.htm">分类游戏</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite166458.htm">热门游戏</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite42994.htm">体育运动</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite872698.htm">手机专区</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite28075.htm">业余爱好</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite34403.htm">影视沙龙</A><BR><A
href="http://www.moon-soft.com/program/bbs/docelite872701.htm">音乐天地</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite872702.htm">数码广场</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite121902.htm">教育园地</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite872703.htm">科学大观</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite991826.htm">古今纵横</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite49868.htm">谈股论金</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite55064.htm">人文艺术</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite165391.htm">医学保健</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite115338.htm">动漫图酷</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite872704.htm">二手专区</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite112364.htm">地方风情</A>┊<A
href="http://www.moon-soft.com/program/bbs/docelite165368.htm">各行各业</A><BR><BR><A
href="http://www.moon-soft.com/">月光软件站</A>·<A
href="http://www.moon-soft.com/sitemap.htm" target=_blank>版权所有</A>
</TD></TR></TBODY></TABLE></CENTER></DIV><BR><BR><BR><BR><BR><BR><!-- */ //--></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -