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

sql °Ñ±íµ¼³É.TXTÎļþ

sql ´úÂë:
---------------------------------------------------------
/*
  a        ±íÃû
  Èç¹ûÔÚsql ²éѯ·ÖÎöÆ÷µ±ÖгöÏÖ
  " SQL Server ×èÖ¹Á˶Ô×é¼þ 'xp_cmdshell' µÄ ¹ý³Ì'sys.xp_cmdshell' µÄ·ÃÎÊ£¬ÒòΪ´Ë×é¼þÒÑ×÷Ϊ´Ë·þÎñÆ÷°²È«ÅäÖõÄÒ»²¿·Ö¶ø±»¹Ø±Õ¡£ÏµÍ³¹ÜÀíÔ±¿ÉÒÔͨ¹ýʹÓà sp_co"Õâ¸ö´íÎ󡣡£ÇëÖ´ÐдúÂ룺
sp_configure 'show advanced options',1
reconfigure
go
sp_configure 'xp_cmdshell',1
reconfigure
*/
declare @sqlstr varchar(3000)
set @sqlstr='bcp "select * from a" queryout "c:\123.txt" -c -T'
exec master.dbo.xp_cmdshell  @sqlstr
×ªÔØ/*http://www.zhujiangroad.com/html/soft/s7773.html*/
·½·¨£­£ºÓÃBCPÃüÁî
bcp ʵÓù¤¾ß
bcp ʵÓù¤¾ßÔÚ Microsoft® SQL Server™ 2000 ʵÀýºÍÊý¾ÝÎļþÖ®¼äÒÔÓû§Ö¸¶¨µÄ¸ñʽ¸´Êý¾Ý¡£
Óï·¨
 
bcp {[[database_name.][owner].]{table_name | view_name} | "query"}
{in | out | queryout | format} data_file
[-m max_errors] [-f format_file] [-e err_file]
[-F first_row] [-L last_row] [-b batch_size]
[-n] [-c] [-w] [-N] [-V (60 | 65 | 70)] [-6]
[-q] [-C code_page] [-t field_term] [-r row_term]
[-i input_file] [-o output_file] [-a packet_size]
[-S server_name[\instance_name]] [-U login_id] [-P password]
[-T] [-v] [-R] [-k] [-E] [-h "hint [,...n]"]
²ÎÊýdatabase_name
Ö¸¶¨µÄ±í»òÊÓͼËùÔÚÊý¾Ý¿âµÄÃû³Æ¡£Èç¹ûδָ¶¨£¬ÔòΪÓû§Ä¬ÈÏÊý¾Ý¿â¡£
owner
±í»òÊÓͼËùÓÐÕßµÄÃû³Æ¡£Èç¹ûÖ´ÐдóÈÝÁ¿¸´ÖƲÙ×÷µÄÓû§ÓµÓÐÖ¸¶¨µÄ±í»òÊÓͼ£¬Ôò owner ÊÇ¿ÉÑ¡µÄ¡£Èç¹ûûÓÐÖ¸¶¨ owner ²¢ÇÒÖ´ÐдóÈÝÁ¿¸´ÖƲÙ×÷µÄÓû§²»ÓµÓÐÖ¸¶¨µÄ±í»òÊÓͼ£¬Ôò Microsoft® SQL Server™ 2000 ½«·µ»Ø´íÎóÐÅÏ¢²¢È¡Ïû´óÈÝÁ¿¸´ÖƲÙ×÷¡£
table_name
Êǽ«Êý¾Ý¸´ÖƵ½ SQL Server ʱ (in) µÄÄ¿µÄ±íÃû£¬ÒÔ¼°´Ó SQL Server ¸´ÖÆÊý¾Ýʱ (out) µÄÔ´±íÃû¡£
view_name
Êǽ«Êý¾Ý¸´ÖƵ½ SQL Server ʱ (in) µÄÄ¿µÄÊÓͼÃû£¬ÒÔ¼°´Ó SQL Server ¸´ÖÆÊý¾Ýʱ (out) µÄÔ´ÊÓͼÃû¡£Ö»ÓÐÆäÖÐËùÓÐÁж¼ÒýÓÃͬһ¸ö±íµÄÊÓͼ²ÅÄÜÓÃ×÷Ä¿µÄÊÓͼ¡£Óйؽ«Êý¾Ý¸´ÖƵ½ÊÓͼµÄÏÞÖÆµÄ¸ü¶àÐÅÏ¢£¬Çë²Î¼û INSERT¡£
Query
ÊÇ·µ»ØÒ»¸ö½á¹û¼¯µÄ Transact-SQL ²éÑ


Ïà¹ØÎĵµ£º

SQL SERVER 2005Êý¾Ý¿â¾µÏñ

ͨ¹ýµÚÆßÆÚºÍµÚ°ËÆÚµÄÎÄÕ£¬ÎÒÃÇÁ˽âÁËSQL SERVER 2005Êý¾Ý¿âµÄÔ­Àí¡¢ÊµÏÖ·½Ê½ÒÔ¼°SQL SERVER 2005Ôڸ߿ÉÓᢸßÐÔÄܺ͸߱£»¤Ä£Ê½Ï»áÓв»Í¬µÄÊý¾Ý¿â¾µÏñ״̬£¬¶øÇÒÁ˽âÁËSQL SERVER 2005ÔÚ²»Í¬Ó¦ÓÃģʽϹÊÕÏ×ªÒÆµÄ·½Ê½¡£½ÓÏÂÀ´£¬ÎÒÃǽ«¸ù¾ÝÒÔÏÂÁ½Ààʼþ¶ÔÊý¾Ý¿â¾µÏñÔ¤ÆÚµÄ¿ÉÓÃÐÔ½øÐзÖÎö£º
Ò»¸ö»ò¶à¸ö·þÎñÆ÷»òÕßÊý¾Ý¿âʧ° ......

SQL ServerË÷Òý¹ÜÀíÖ®Áù´óÌúÂÉ


Ô­ÎÄת×Ô:http://tech.it168.com/a2009/0218/265/000000265868.shtml
Ë÷ÒýÊÇÒÔ±íÁÐΪ»ù´¡µÄÊý¾Ý¿â¶ÔÏó¡£Ë÷ÒýÖб£´æ×űíÖÐÅÅÐòµÄË÷ÒýÁУ¬²¢ÇҼͼÁËË÷ÒýÁÐÔÚÊý¾Ý¿â±íÖеÄÎïÀí´æ´¢Î»Öã¬ÊµÏÖÁ˱íÖÐÊý¾ÝµÄÂß¼­ÅÅÐò¡£Í¨¹ýË÷Òý£¬¿ÉÒÔ¼Ó¿ìÊý¾ÝµÄ²éѯËٶȺͼõÉÙϵͳµÄÏìӦʱ¼ä;¿ÉÒÔʹ±íºÍ±íÖ®¼äµÄÁ¬½ÓËٶȼӿ졣
  µ«ÊÇ£¬ ......

sql ²éѯ³öÀ´Ò»¸ö±íÔÚ²åÈëµ½ÁíÒ»¸ö±íÀï

ALTER  FUNCTION  [dbo].[fun_tongji]()
RETURNS  @t1 table (
  yue int ,
  money int
 )
AS
begin
 Declare @i int
 set @i=1
-- declare @t1 table (
--  yue int ,
--  money int
-- )
 while (@i<=12)&n ......

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, ÈôÎļþ´æÔÚÔòÖØÐ´Îļþ, ²»´æÔÚÔò´´½¨Îļþ
  ......

sql±¸·ÝÊý¾Ý¿âÓï¾ä:SQL±¸·ÝÓï¾ä

--ÍêÕû±¸·Ý
Backup Database NorthwindCS
To disk='G:\Backup\NorthwindCS_Full_20070908.bak'
--²îÒ챸·Ý
Backup Database NorthwindCS
To disk='G:\Backup\NorthwindCS_Df_20070908.bak'
With Dferential
--ÈÕÖ¾±¸·ÝĬÈϽضÏÈÕÖ¾
Backup Log NorthwindCS
To disk='G:\Backup\NorthwindCS_Log_20070908. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ