SQL 2000 ·ÖÒ³
SELECT TOP 10 *
from HumanResources.Employee
WHERE EmployeeID NOT IN (SELECT TOP 0 EmployeeID from HumanResources.Employee ORDER BY EmployeeID desc)
ORDER BY EmployeeID desc
————————————————————
SELECT TOP ·ÖÒ³´óС * from ±íÃû where Ö÷¼ü not in (select top µ±Ç°Ò³¼õ1*·ÖÒ³´óС from ±íÃû order by Ö÷¼ü)
order by Ö÷¼ü
Ïà¹ØÎĵµ£º
1>ͨ¹ýÆóÒµ¹ÜÀíÆ÷½øÈë²éѯ·ÖÎöÖ´ÐУº
EXEC sp_password NULL, 'ÄãµÄÐÂÃÜÂë', 'sa'
Èç¹ûÄãÔÚNTÏÂ(°üÀ¨2000)×°µÄSQL Server£¬Ôò¿ÉÒÔÕâÑù×ö£º
Ö±½Ó´ò¿ª"²éѯ·ÖÎöÆ÷"(×¢Òâ²»ÊÇ´Ó"ÆóÒµ¹ÜÀíÆ÷"ÖнøÈë,¿ÉÒÔ´Ó¿ªÊ¼²Ëµ¥µÄ³ÌÐò×é½øÈ¥,Èç¹ûÕÒ²»µ½µÄ»°,Ö±½ÓÔÚ"ÔËÐÐ"ÖÐÊäÈë"isqlw.exe"Ò²¿É);
Ñ¡Ôñ"WindowsÉí·ÝÑéÖ¤"½øÈë,²»ÐèÒªÊäÈ ......
SQLÈÕÆÚʱ¼ä²»ÄÜÔçÓÚ1753Äê
1.¹«ÔªÔªÄêµÄµÚÒ»Ì죬Ҳ¾ÍÊǹ«Ôª1Äê1ÔÂ1ÈÕ£¬ÄÇÌìÊÇÐÇÆÚÁù¡£
2.
ÏÖÐеĹ«ÀúÊǸñÀû¸êÀïÀú·¨£¬Õâ¸öÀú·¨²¢²»ÊÇÁ¬ÐøµÄ£¬ÖмäȱÉÙÁË11Ìì¡£1752Äê9ÔÂ2ÈյĺóÒ»Ìì²¢²»ÊÇ9ÔÂ3ÈÕ£¬¶øÊÇ9ÔÂ14ÈÕ¡£Ò²¾ÍÊÇ˵£¬´Ó1752Äê9ÔÂ3ÈÕµ½9ÔÂ13ÈÕµÄ11Ìì²¢²»´æÔÚ¡£
&nb ......
SQL Server CONVERT() º¯Êý
¶¨ÒåºÍÓ÷¨
CONVERT() º¯ÊýÊǰÑÈÕÆÚת»»ÎªÐÂÊý¾ÝÀàÐ͵ÄͨÓú¯Êý¡£
CONVERT() º¯Êý¿ÉÒÔÓò»Í¬µÄ¸ñʽÏÔʾÈÕÆÚ/ʱ¼äÊý¾Ý¡£
Óï·¨
CONVERT(data_type(length),data_to_be_converted,style)
data_type(length) ¹æ¶¨Ä¿±êÊý¾ÝÀàÐÍ£¨´øÓпÉÑ¡µÄ³¤¶È£©¡£data_to_be_converted º¬ÓÐÐèҪת»»µÄÖµ¡£styl ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE data ......
Õª Òª£º±¾ÎÄÌÖÂÛÁËOracleºÍSQL ServerµÄÔÚÊÂÎñ´¦ÀíÉϵÄÇø±ð£¬²¢·ÖÎöÁËÆäʵÏÖ»úÖÆµÄ²îÒì¡£
¹Ø¼ü´Ê£ºOracle£»SQL Server£»ÊÂÎñ£»ÊÂÎñ¸ôÀë¼¶±ð£»DDL¡£
ÊÂÎñ´¦ÀíÊÇËùÓдóÐÍÊý¾Ý¿â²úÆ·µÄÒ»¸ö¹Ø¼üÎÊÌ⣬¸÷Êý¾Ý¿â³§É̶¼ÔÚÕâ¸ö·½Ã滨·ÑÁ˺ܴó¾«Á¦£¬²»Í¬µÄÊÂÎñ´¦Àí·½Ê½»áµ¼ÖÂÊý¾Ý¿âÐÔÄܺ͹¦ÄÜÉϵľ޴ó²îÒì¡£
ÊÂÎñ´¦ÀíÒ²ÊÇÊý¾Ý¿â¹Ü ......