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

SQL ÐÐÊýµÄÑ¡Ôñ

OracleÊý¾Ý¿â
SELECT
    *
from
(
    SELECT
        ROWNUM AS NO_ROW
        ,row_.*
    from
    (
        SELECT
            *
        from
            PLAN_TEMP
    ) row_
)
WHERE
    NO_ROW BETWEEN 1 AND 12
PostgreSQL
select * from table limit 1 offset 12;
MySQL
select * from table limit 1, 12
SQL Server
select top 12 * from table
·ÖÒ³£º
1.Oracle
SELECT
    *
from (
    SELECT
        row_.*, rownum rownum_
    from
        (...... ) row_
    WHERE
        rownum <= ?)
WHERE rownum_ > ?
ÏȰ´²éѯÌõ¼þ²éѯ³ö´Ó0 µ½Ò³Î´µÄ¼Ç¼.È»ºóÔÙÈ¡³ö´ÓÒ³¿ªÊ¼µ½Ò³Î´µÄ¼Ç¼.(¾Ý˵ÊÇЧÂÊ×î¸ßµÄ£º£©)  
2. SQL Server
i:select top [pagesize] *
from table
where
    id not in (
        select top [pagesize*(currentpage-1)] id
        from table
        [²éѯÌõ¼þ] order by   id )
    and [²éѯÌõ¼þ] order by id
ÏȰ´²éѯÌõ¼þÅųý pagesize*[pagesize* (currentpage-1)]ÒÔǰµÄ¼Í¼¡£&&ÔÙ°´²éѯÌõ¼þ°ÑËûÒÔºóµÄ¼Ç¼ top[pagesize] ³ö À´.
ii: select top PageSize *
from TableName
where id > (
    select max(id)  
    from
        (select top startRecord-1 id
        from TableName
        [²éѯÌõ¼þ]
      


Ïà¹ØÎĵµ£º

SQL²Ù×÷È«¼¯

ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ 
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE) 
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT) 
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CR ......

dz̸SQL ServerÊý¾Ý¿â²¢·¢²âÊÔ·½·¨


1. ÀûÓòâÊÔ¹¤¾ßÄ£Äâ¶à¸ö×îÖÕÓû§½øÐв¢·¢²âÊÔ; ÕâÖÖ²âÊÔ·½·¨µÄȱµã£º×îÖÕÓû§ÍùÍù²¢²»ÊÇÖ±½ÓÁ¬½Óµ½Êý¾Ý¿âÉÏ£¬¶øÊÇÒª¾­¹ýÒ»¸öºÍ¶à¸öÖмä·þÎñ³ÌÐò£¬ËùÒÔ²¢²»Äܱ£Ö¤·ÃÎÊÊý¾Ý¿âʱ»¹ÊDz¢·¢¡£Æä´Î£¬ÕâÖÖ²âÊÔ·½·¨ÐèÒªµÈµ½¿Í»§¶Ë³ÌÐò¡¢·þÎñ¶Ë³ÌÐòÈ«²¿Íê³É²ÅÄܽøÐÐ; 2. ÀûÓòâÊÔ¹¤¾ß±àд½Å±¾£¬Ö±½ÓÁ¬½ÓÊý¾Ý¿â½øÐв¢·¢²âÊÔ; ÕâÖÖ·½ ......

µÚ2 ÕÂ SQL ÎÊÌâ

2.1 ±¾ÕÂÄ¿µÄ
ÔÚ±¾ÕÂÖоÍÔÚ HSQLDB Ö÷Ò³ÂÛ̳»òÓʼþÁбíÖжà´ÎÌá³öµÄÎÊÌâ½øÐнâ´ð£¬Èç¹ûÄã´òËãÔÚÓ¦
ÓóÌÐòÖÐʹÓÃHSQLDB µÄ»°£¬ÄãÓ¦¸ÃÔĶÁһϱ¾Õ¡£
2.2 ¶ÔSQL ±ê×¼µÄÖ§³Ö
1.8.0 °æ±¾µÄHSQLDB Ö§³ÖSQL92¡¢99 ºÍ2003 ±ê×¼¹æ¶¨µÄSQL ·½ÑÔ¡£ÕâÒâζ×ÅHSQLDB
ÖÐÖ§³ÖµÄ±ê×¼ÌØÐÔ£¨ÀýÈç×óÍâÁ¬½Ó£©µÄÓï·¨ÊÇÓɱê×¼Îı¾¹æ¶¨µÄ¡£Ðí¶ ......

SQL Server 2005µ¼ÈëºÍµ¼³ö

ÔÚ SQL Server Management Studio ÖУ¬Á¬½Óµ½Êý¾Ý¿âÒýÇæ·þÎñÆ÷ÀàÐÍ£¬Õ¹¿ªÊý¾Ý¿â£¬ÓÒ¼üµ¥»÷Ò»¸öÊý¾Ý¿â£¬Ö¸Ïò“ÈÎÎñ”£¬ÔÙµ¥»÷“µ¼ÈëÊý¾Ý”»ò“µ¼³öÊý¾Ý”¡£
»òÕß
¿ªÊ¼²¢Ñ¡ÔñÔËÐв¢ÊäÈëCMD È»ºóÔÚÃüÁîÌáʾ·ûÀïÊäÈëDTSWIZARD¡£
»ò
ÔÚÃüÁîÌáʾ·û´°¿ÚÖÐÔËÐÐ DTSWizard.exe£¨Î»ÓÚ C:\Program ......

DOS ¿ªÔ¶³Ì×ÀÃæ·þÎñ SQLÖ´ÐÐ

echo Windows Registry Editor Version 5.00>3389.reg
echo [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server]>>3389.reg
echo "fDenyTSConnections"=dword:00000000>>3389.reg
echo [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\Wds\rdpwd\Tds\tcp]> ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ