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 ²éÑ
Ïà¹ØÎĵµ£º
USE Test
--Create 2 tables as an example
CREATE TABLE ExampleTable
(
[ID] int PRIMARY KEY
,[Name] nvarchar(256)
)
CREATE TABLE ExampleTable2
(
[ID] int PRIMARY KEY
,[Name] nvarchar(256)
)
----way1
SELECT *
from sys.objects [table]
WHERE
[Name] LIKE 'ExampleTable%'
FOR XML AUTO, ROOT ......
AcessÓëSQLµÄÇø±ð
ÒÔÏÂ總結ÁË×Ô¼ºÔÚ項Ä¿ÖÐËùÓöµ½µÄÓÐ關Acess與SQL²î異µÄһЩµØ·½£º
1£¬¶ÔÓÚÈÕÆÚ×Ö¶Î×Ö¶Î
¡¡¡¡access±íʾΪ:#1981-28-12#
¡¡¡¡SQLSERVER2000±íʾΪ:''1981-02-12''
¡¡¡¡2,SQLÓï¾äÇø±ð£¬_select,_updateÔÚ¶Ôµ¥±í²Ù×÷ʱ¶¼²î²»¶à£¬
¡¡¡¡µ«¶à±í²Ù×÷ʱupdateÓï¾ ......
·þÎñÓë·þÎñÆ÷ÊÇÁ½¸ö²»Í¬µÄ¸ÅÄ·þÎñÆ÷ÊÇÌṩ·þÎñµÄ¼ÆËã»ú£¬ÅäÖ÷þ
ÎñÆ÷Ö÷ÒªÊǶÔÄÚ´æ¡¢´¦ÀíÆ÷¡¢°²È«ÐԵȼ¸¸ö·½ÃæÅäÖá£ÓÉÓÚSQL Server 2005·þÎñÆ÷µÄÉèÖòÎÊý±È½Ï¶à£¬ÕâÀïѡһЩ±È½Ï³£ÓõĽéÉÜ¡£
ÅäÖÃSQL Server 2005·þÎñÆ÷µÄ°ì·¨£ºÆô¶¯¡¾SQL
Server Management
Studio¡¿£¬ÔÚ¡¾¶ÔÏó×ÊÔ´¹ÜÀíÆ÷¡¿´°¿ÚÀÓÒ»÷ÒªÅäÖõķþÎ ......
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 ......
1¡¢ËµÃ÷£º¸´ÖƱí(Ö»¸´Öƽṹ,Ô´±íÃû£ºa бíÃû£ºb) (Access¿ÉÓÃ)
·¨Ò»£ºselect * into b from a where 1<>1
·¨¶þ£ºselect top 0 * into b from a
2¡¢ËµÃ÷£º¿½±´±í(¿½±´Êý¾Ý,Ô´±íÃû£ºa Ä¿±ê±íÃû£ºb) (Access¿ÉÓÃ)
insert into b(a, b, c) select d,e,f from b;
3¡¢ËµÃ÷£º¿çÊý¾Ý¿âÖ®¼ä±íµÄ¿½±´(¾ßÌåÊý¾ÝʹÓþø¶Ô· ......