Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL Server Out Put Excel File

SQL Server Out Put Excel File
ÔÚ SQL ServerÖÐ, µ¼³öEXCEL Îļþ, Óõ½ bcp.exe
 
 bcp  µ¼³öµÄ±¾ÖÊÊÇ´¿Îı¾Îĵµ,
ÈôÊý¾Ýº¬ÓÐÖÐÎÄ,Çëµ¼³öµ½ÖÐÎİæEXCEL,»òTXTÎĵµµÈ, ·ñÔòÂÒÂë....
ÓÃTXT ´ò¿ªÓ¢ÎİæEXCEL,Ò²¿ÉÒÔ,
 
µ¼³ö Êý¾Ýµ½C:\authors.xls, ÈôÎļþ´æÔÚÔòÖØÐ´Îļþ, ²»´æÔÚÔò´´½¨Îļþ
 
Exec master..xp_cmdshell 'bcp "select [DBName].dbo.[TableName].* from [DBName].dbo.[TableName] where [ColumnName] = Value" queryout C:\authors.xls -c -S".\SQLExpress" -U"sa" -P"Password"'
 
select SQLÓï¾ä¸ù¾Ýʵ¼ÊÐèÒªÀ´ÖØÐ´
 
µ¼³öÎļþÖ»ÓÐÊý¾Ý,ûÓбíÍ·.
 
Èç¹û, ÐèÒª´ø±íÍ·, ÔòÒªÔ¤ÏÈÉèÖúñíÍ·, Óà insert into ·½·¨.
 
insert into OPENROWSET('MICROSOFT.JET.OLEDB.4.0' ,'Excel 8.0;HDR=YES;DATABASE=C:\author.xls',Sheet1$) select [DBName].dbo.[TableName].* from [DBName].dbo.[TableName] where [ColumnName] = Value
 
select SQLÓï¾ä¸ù¾Ýʵ¼ÊÐèÒªÀ´ÖØÐ´
Èç¹û,ÐèÒª±íÍ·, ¶øÇÒÊǵ¥±íµ½³ö, Çë·ÃÎÊÒÔÏÂÍøÖ·
1. ʹÓÃSQLÓï¾ä
http://blog.csdn.net/fcfd86/archive/2010/02/26/5329430.aspx
2. ʹÓô洢¹ý³Ì
http://blog.csdn.net/fcfd86/archive/2010/02/26/5329446.aspx


Ïà¹ØÎĵµ£º

sql ³£ÓõĴúÂë

£¨1£©
Mcirosoft JET SQL ÖУ¬ÈÕÆÚÓÑ#’¶¨½ç¡£ÈÕÆÚÒ²¿ÉÒÔÓÃDatevalue()º¯ÊýÀ´´úÌæ¡£ÔڱȽÏ×Ö·ûÐ͵ÄÊý¾Ýʱ£¬Òª¼ÓÉϵ¥ÒýºÅ’’£¬Î²¿Õ¸ñÔڱȽÏÖб»ºöÂÔ¡£
Àý£º
WHERE OrderDate>#96-1-1#
Ò²¿ÉÒÔ±íʾΪ£º
WHERE OrderDate>Datevalue(‘1/1/96’)
ʹÓà NOT ±í´ïʽÇó·´¡£
Àý£ ......

SQLÊý¾Ý¿â Ô¤·À·Ç·¨±íD99_Tmp,kill_kkµÄ½¨Á¢

·ÀÖ¹·Ç·¨±íD99_Tmp,kill_kkµÄ³öÏÖÊÇ·ÀÖ¹ÎÒÃǵÄÍøÕ¾²»±»¹¥»÷,ͬʱҲÊÇSQL°²È«·À·¶Ò»µÀ±ØÒªµÄ·ÀÏß,Ëä˵ÀûÓÃÕâÖÖ·½Ê½¹¥»÷µÄÈ˶¼ÊǺڿÍÖеÄСÄñ,µ«ÊÇÎÒÃÇÒ²²»µÃ²»·À,ÒÔÃâÔì³É²»¿ÉÏëÏóµÄºó¹û,·Ï»°²»¶à˵ÁË,˵Ï·À·¶·½·¨:
xp_cmdshell¿ÉÒÔÈÃϵͳ¹ÜÀíÔ±ÒÔ²Ù×÷ϵͳÃüÁîÐнâÊÍÆ÷µÄ·½Ê½Ö´Ðиø¶¨µÄÃüÁî×Ö·û´®,²¢ÒÔÎı¾Ðз½Ê½·µ»ØÈκÎÊ ......

SQL MINUSµÄÓ÷¨


< type="text/javascript">
document.body.oncopy = function() {
if (window.clipboardData) {
setTimeout(function() {
var text = clipboardData.getData("text");
......

4.5 ÅäÖÃSQL Server 2005·þÎñÆ÷

·þÎñÓë·þÎñÆ÷ÊÇÁ½¸ö²»Í¬µÄ¸ÅÄ·þÎñÆ÷ÊÇÌṩ·þÎñµÄ¼ÆËã»ú£¬ÅäÖ÷þ
ÎñÆ÷Ö÷ÒªÊǶÔÄÚ´æ¡¢´¦ÀíÆ÷¡¢°²È«ÐԵȼ¸¸ö·½ÃæÅäÖá£ÓÉÓÚSQL Server 2005·þÎñÆ÷µÄÉèÖòÎÊý±È½Ï¶à£¬ÕâÀïѡһЩ±È½Ï³£ÓõĽéÉÜ¡£
ÅäÖÃSQL Server 2005·þÎñÆ÷µÄ°ì·¨£ºÆô¶¯¡¾SQL
Server Management
Studio¡¿£¬ÔÚ¡¾¶ÔÏó×ÊÔ´¹ÜÀíÆ÷¡¿´°¿ÚÀÓÒ»÷ÒªÅäÖõķþÎ ......

sql server 2000 ³£¼û´íÎó£¬ÏµÍ³126´íÎó£¡

×ªÔØ£º
http://blog.sina.com.cn/s/blog_5f4ed9cb0100dza0.html
http://wowh.wuyan.org/2008/04/15/sqlserver-2k-system-error-126/
ÔÚ°²×°sql server ¾­³£Óöµ½ÕâÑù¡¢ÄÇÑùµÄ´íÎ󣬽ñÌìÔÚËѵ½±È½ÏÈ«ÃæµÄ£¬¾ÍÌù³öÀ´£¬·ÖÏíÏ£¡
SQL
Server°²×°ÎÊÌâ´óÈ«
(2007-09-06
09:24:28)
±êÇ©£ºIT/¿Æ¼¼
 
Ò¼¡£WINDOWS XP ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ