SQLѧϰ(һ)
ÒÔǰѧϰÁËSQLÏà¹Ø·½ÃæµÄ֪ʶ£¬¶ÔÒ²ÄÜÏà¶ÔÊìÁ·Ê¹ÓÃSQL£¬µ«Ëæ×ŽøÒ»²½µÄʹÓ㬷¢ÏÖ×Ô¼ºËƺõÓÖʲô¶¼²»¶®£¬ÒòΪ×Ô¼ºÖ»ÖªµÀÈçºÎʹÓ㬲»ÖªµÀʹÓõÄÊÇʲôÔÀí£¬ÕâÑùµÄÒ²Ö»ÄÜ˵ÊÇÒ»¸öÊìÁ·Ê¹Óù¤£¬ÏÖÔÚÖØÐÂѧϰһ±é£¬Ï£ÍûÔÚ±ðÈËÎÊÎÒÖ®ËùÒÔÈ»µÄʱºò£¬Ò²Äܻشð¸öÒ»¶þÈý¡£
Ò»¡¢Çø±ðÊÂÎñÓëÆÕͨ³ÌÐòµÄÌØÕ÷ͨ³£ËõдΪACIDÐÔÖÊ
Ô×ÓÐÔ(Atomic) ÊÂÎñҪô±»ÍêȫִÐУ¬ÒªÃ´¸ù±¾Ã»Óб»Ö´ÐЗ—Ìá½»¡¢Òì³£ÖÐÖ¹¡¢»ØÍË¡£
Ò»ÖÂÐÔ(Consistent) ÊÂÎñά»¤Êý¾Ý¿âµÄÒ»ÖÂÐÔ——ÊÂÎñ·ÃÎʺ͸üÐÂÊý¾Ý¿âʱ±ØÐë×ñÊØËùÓеÄÊý¾Ý¿âÍêÕûÐÔÔ¼Êø;ÿ¸öÊÂÎñ±ØÐë¸üÐÂÊý¾Ý¿âʹµÃÐÂÊý¾Ý¿â״̬·´Ó³±»½¨Ä£µÄÏÖʵÆóÒµµÄ״̬¡£
¸ôÀëÐÔ(Isolated) ÊÂÎñ¼¯ºÏµÄ²¢·¢Ö´ÐÐÓëij¸ö˳ÐòÖ´ÐеÄЧ¹ûÒ»Ñù——¸ôÀëÐԵȼ¶Ö´ÐÐÑ¡Ïî¡£
³Ö¾ÃÐÔ(Durable) ÊÂÎñÌá½»ºóµÄЧ¹ûÓÀ¾Ã¼Ç¼ÔÚÊý¾Ý¿âÖЗ—Èç¹ûÒ»¸ö³ÌÐò³É¹¦µØ¸üÐÂÍêÎļþºó£¬´æ´¢ÃºÖÊ·¢Éú¹ÊÕÏ£¬Îļþ´æ´¢µÄ¿ÉÄܲ»ÊǸüйýµÄÊý¾Ý¡£
Ïà¹ØÎĵµ£º
SELECT ROWNUM AS ID
,TO_CHAR(SYSDATE + ROWNUM / 24 / 3600, 'yyyy-mm-dd hh24:mi:ss') AS INC_DATETIME
,TRUNC(DBMS_RANDOM.VALUE(0, 100)) AS RANDOM_ID
,DBMS_RANDOM.STRING('x', 20) RANDOM_STRING
from DUAL
CONNECT BY LEVEL <= 10;
SELECT '('||WMSYS.WM_CONCAT(':P' || ROWNUM)| ......
SQLÓï¾äµ¼Èëµ¼³ö
/******* µ¼³öµ½excel
EXEC master..xp_cmdshell 'bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P""'
/*********** µ¼ÈëExcel
SELECT *
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended propert ......
À´×Ôhttp://hi.baidu.com/zcy60156/blog/item/42b6c5802a33859af603a685.html
ÍÆ¼öÊÇÓô洢¹ý³Ì¼ÓÊÂÎñʵÏÖ.»òÖ±½ÓÔÚaspÀïд¼ÓÉÏÊÂÎñ¾Í¿ÉÒÔͬʱµÄ²åÈëÁË.Èç¹ûÖмä³ö´íµÄ»°»¹Äܻعö,¿É±£³ÖÊý¾ÝµÄÒ»ÖÂÐÔ.È¥baiduÉÏËÑË÷Ò»ÏÂÊÂÎñµÈµÄÏà¹Ø×ÊÁϺܶàµÄ.
ÔÚ¿ª·¢WebÓ¦ÓÃʱ£¬ÎÞÒ»ÀýÍâµØÐèÒª·ÃÎÊÊý¾Ý¿â£¬ÒÔÍê³É¶ÔÊý¾ÝµÄ²éѯ¡¢²åÈë¡¢¸ ......
1¡¢±í²Ù×÷¡£
1.1 ÏÖÓбíÔö¼Ó×Ö¶Î
alter table TableName add
columnName1 varchar(2) NULL,
columnName2 varchar(2) NULL,
columnName3 varchar(2) NULL
×¢Ò⣺²»ÓüÓColu ......
@echo off
rem Input Parameters:
rem 1 -Server Name
rem 2 -Database Name
if "%1"=="" goto ERROR
if "%2"=="" goto ERROR
@rem Make variables local
@Setlocal
@rem set variables from input parameters
set Server=% 1
set DBName=% 2
@rem------------------------------------------------------------ ......