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

SQLÓï¾äÓÅ»¯

¶ÔͬһÕÅ±í½øÐÐÁ½ÖÖ·½Ê½²éѯ£¨½á¹û¼¯Ïàͬ£©£º
case1 ²éѯÌõ¼þ:°üÀ¨¼ÆËã»úÃû£¬êdzƣ¬Ìí¼Óʱ¼äµÈµÈһЩÏÞÖÆÌõ¼þ×ֶΡ£¶øÇÒÐèÁª±í²éѯ±ðµÄ±í
²éѯÊý¾ÝÁ¿£º             100Íò       200Íò
µ¥´¿Ö´ÐÐSQLÓï¾äËùÐèʱ¼ä£º31ºÁÃë       31ºÁÃë
Ñ­»·±éÀúÊý¾Ý¼¯ËùÐèʱ¼ä£º 57Ãë        1·Ö50Ãë
case 2²éѯÌõ¼þ£ºÎÞ
select * from ¡¾±í¡¿
²éѯÊý¾ÝÁ¿£º             100Íò        200Íò
µ¥´¿Ö´ÐÐSQLÓï¾äËùÐèʱ¼ä£º31ºÁÃë      31ºÁÃë
Ñ­»·±éÀúÊý¾Ý¼¯ËùÐèʱ¼ä£º 20Ãë        40Ãë
×¢ÒâÏÂÑ­»·±éÀúÊý¾Ý¼¯Ê±¼ä£¨×ÝÏò100ÍòµÄ£¬»òÕß200ÍòµÄ¶¼ÐУ©£¬²éѯÌõ¼þ²»Ò»Ñù£¬¾¡¹Ü×îÖÕ²éѯÊý¾ÝÁ¿ÊÇÒ»ÑùµÄ£¬µ«ÊDZéÀúʱ¼ä²î±ðºÜ´ó¡£
ÎªÊ²Ã´ÄØ£¿
¿É²»¿ÉÒÔÕâôÀí½â£¬SQLÓï¾äÔ½¸´ÔÓ£¨»òÕß˵ÓÅ»¯³Ì¶ÈûÄÇô¸ß£©£¬Ó°ÏìµÄ²»ÊÇSQL±¾ÉíµÄÖ´ÐУ¬¶øÊÇÊý¾ÝµÄÌáÈ¡ÄØ£¿


Ïà¹ØÎĵµ£º

SqlÔÚMysqlµÄÖ´ÐÐ

     ×òÌì½âÎöÁËdblp.xml£¬´æÈëÊý¾Ý¿â£¬Éú³ÉÁËÈô¸ÉÕÅÁÙʱ±í¡£½ñÌìÉÏÎ磬¶ÔÕâЩÁÙʱ±í½øÐд¦Àí£¬È»ºó´æÈëʵÑéÉè¼ÆµÄ±íÖС£Êý¾Ý¿âµÄÊý¾ÝÁ¿±È½Ï´ó£¬50¶àM£¬80¶àÍòÌõ¼Ç¼¡£Òò¶øÖ´ÐÐsqlʱ£¬¾ÍÓöµ½Á˺ܶàÎÊÌâ¡£
1¡¢È¥³ýÖØ¸´tuple
     ԭʼdblp.xmlÖУ¬Í¬Ò»ÂÛÎĵĴæÔÚ¼¸¸öÍêÈ«ÏàͬµÄ&l ......

sqlÈçºÎ²úÉú¶àÌõ¼Ç¼

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Óï¾äµ¼Èëµ¼³ö

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 ......

SQLº¯Êý


SQLº¯Êý
ÔÚSQLÖУ¬º¯Êý¶ÔÊý¾Ý»òÊý¾Ý×éÖ´ÐвÙ×÷£¬È»ºó·µ»ØÐèÒªµÄÖµ¡£º¯Êý±í´ïʽ¿ÉÒÔ³öÏÖÔÚSELECTÁбíÖУ¬»òÕß
ÔÚÈκÎÔÊÐí³öÏÖµÄλÖÃÉÏ¡£SQL°üº¬ÁËÆßÖÖº¯Êý:
(1)¾ÛºÏº¯Êý:·µ»Ø»ã×ÜÖµ¡£
(2)תÐͺ¯Êý:½«Ò»ÖÖÊý¾ÝÀàÐÍת»»ÎªÁíÍâÒ»ÖÖ¡£
(3)ÈÕÆÚº¯Êý:´¦ÀíÈÕÆÚºÍʱ¼ä¡£
(4)Êýѧº¯Êý:Ö´ÐÐËãÊõÔËËã¡£
(5)×Ö·û´®º¯Êý:¶Ô×Ö·û´ ......

Sql Server Éú³ÉÊý¾Ý×Öµä

use Dbname  
go  
select   
    [±íÃû]=c.Name,  
    [±í˵Ã÷]=isnull(f.[value],''),  
    [ÁÐÃû]=a.Name,  
    [ÁÐÐò號]=a.Column_id,  
 &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ