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

sql²éѯÖÐÏÔʾÐòºÅ

sql²éѯÖÐÏÔʾÐòºÅ
2009-06-04 09:27
/* ·½·¨Ò»*/
SELECTÐòºÅ= (SELECT COUNT(¿Í»§±àºÅ) from ¿Í»§ AS LiMing
                   WHERE LiMing.¿Í»§±àºÅ<= Chang.¿Í»§±àºÅ),
   ¿Í»§±àºÅ,¹«Ë¾Ãû³Æ
from¿Í»§ AS Chang ORDER BY 1;
GO
/* ·½·¨¶þ: ʹÓÃSQL Server 2005 ¶ÀÓеÄRANK() OVER () Óï·¨*/
SELECT RANK() OVER (ORDER BY ¿Í»§±àºÅ DESC) AS ÐòºÅ,
      ¿Í»§±àºÅ,¹«Ë¾Ãû³Æ
from¿Í»§;
GO
/* ·½·¨Èý*/
SELECTÐòºÅ= COUNT(*), LiMing.¿Í»§±àºÅ, LiMing.¹«Ë¾Ãû³Æ
from ¿Í»§ AS LiMing, ¿Í»§AS Chang
WHERE LiMing.¿Í»§±àºÅ>= Chang.¿Í»§±àºÅ
GROUP BY LiMing.¿Í»§±àºÅ, LiMing.¹«Ë¾Ãû³Æ
ORDER BY ÐòºÅ;
GO
/* ·½·¨ËÄ
½¨Á¢Ò»¸ö¡¸×Ô¶¯±àºÅ¡¹µÄ×ֶΣ¬È»ºó½«Êý¾ÝÐÂÔöÖÁÒ»¸öÇøÓòÐÔÔÝ´æÊý¾Ý±í£¬
È»ºóÓɸÃÇøÓòÐÔÔÝ´æÊý¾Ý±íÖУ¬½«Êý¾Ýѡȡ³öÀ´£¬×îºóɾ³ý¸ÃÇøÓòÐÔÔÝ´æÊý¾Ý±í
*/
SELECTÐòºÅ= IDENTITY(INT,1,1),¹ÜµÀ,³ÌÐòÓïÑÔ,½²Ê¦,×ÊÀú
INTO #LiMing
fromÎÊȯµ÷²éÒ»;
GO
SELECT * from #LiMing;
GO
DROP TABLE #LiMing;
GO
/*
·½·¨Îå
ʹÓà SQL Server 2005 ¶ÀÓеÄROW_NUMBER() OVER () Óï·¨
´îÅä CTE £¨Ò»°ãÊý¾Ý±í±í´ïʽ£¬¾ÍÊÇ WITH ÄǶÎÓï·¨£©Ñ¡È¡ÐòºÅ2 ~ 4 µÄÊý¾Ý
*/
WITHÅÅÐòºóµÄͼÊé AS
(SELECT ROW_NUMBER() OVER (ORDER BY ¿Í»§±àºÅ DESC) AS ÐòºÅ,
   ¿Í»§±àºÅ,¹«Ë¾Ãû³Æ
from ¿Í»§)
SELECT * from ÅÅÐòºóµÄͼÊé
WHEREÐòºÅ BETWEEN 2 AND 4;
GO


Ïà¹ØÎĵµ£º

oracleÖÐsql loaderµÄÓ÷¨

sql loader ¹¤¾ßËü¿ÉÒÔ°ÑһЩÒÔÎı¾¸ñʽ´æ·ÅµÄÊý¾Ý˳ÀûµÄµ¼Èëµ½oracleÊý¾Ý¿âÖУ¬ÊÇÒ»ÖÖÔÚ²»Í¬Êý¾Ý¿âÖ®¼ä½øÐÐÊý¾ÝÇ¨ÒÆµÄ·Ç³£·½±ã¶øÇÒͨÓõŤ¾ß¡£È±µã¾ÍËٶȱȽÏÂý£¬ÁíÍâ¶ÔblobµÈÀàÐ͵ÄÊý¾ÝÓеãÂé·³¡£
ÔÚDOCÏÂÃæÊäÈ룺sqlldr userid=user/password@sid control=result.ctl
Àý×Ó:
SQLLDR USERID=zero/zero@ORACLE CONTROL ......

Æô¶¯PL/SQL Developer ±¨×Ö·û±àÂë²»Ò»Ö´íÎó

´íÎóÈçÏ£º
Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different.
Character set conversion may cause unexpected results.
Note: you can set the client character set through the NLS_LANG environment variable or the NLS_LANG registry key in
HKEY_LOCAL_MACHINE\SOFTWARE\ ......

SQL Server 2000

1. ¼òµ¥ÐðÊöSQL Server 2000µÄ°²È«ÈÏÖ¤¹ý³Ì¡£
´ð£ºSQL Server 2000ÖУ¬ÏµÍ³Óüì²é¿ÚÁî¡¢ÉèÖýÇÉ«¡¢Ðí¿ÉµÈÊÖ¶ÎÀ´¼ì²éÓû§µÄÉí·Ý¼°Ê¹ÓÃȨÏÞ¡£ºÏ·¨µÄÓû§²ÅÄܽøÈëÊý¾Ý¿âϵͳ£¬µ±Óû§¶ÔÊý¾Ý¿âÖ´ÐвÙ×÷ʱ£¬ÏµÍ³×Ô¶¯¼ì²éÓû§ÊÇ·ñÓÐȨÏÞÖ´ÐÐÕâЩ²Ù×÷¡£Ò»¸öÓû§Èç¹ûÒª·ÃÎÊSQL ServerÊý¾Ý¿âÖеÄÊý¾Ý£¬Ëû±ØÐëÒª¾­¹ýÈý¸öÈÏÖ¤¹ý³Ì¡£
£ ......

SQL Server 2008ÐÂÌØÐÔ£­Êý¾ÝѹËõ

Êý¾ÝѹËõ£¨Data Compression£©ÊÇSQL Server 2008ÒýÈëµÄÐÂÌØÐÔÖ®Ò»£¬ÕâÏî¼¼ÊõʹÊý¾Ý¸üÓÐЧµÄ±£´æ²¢ÇÒ¼«´ó¼õÉÙÁË´æ´¢¿ªÏú£¬Í¬Ê±Ò²´øÀ´ÁËÐÔÄÜÉϵÄÏÔÖøÌá¸ß£¬ÓÈÆäÊǶÔÐèÒª´óÁ¿´ÅÅÌI/OµÄÊý¾Ý²Ö¿â¡£
 
×¢£ºÆäʵÔÚSQL Server 2005 SP2°æ±¾ÖУ¬ÒѾ­ÒýÈëÁË vardecimal £¬ËüʹÓñ䳤µÄ¸ñʽ´æ´¢¶¨³¤µÄdecimalºÍnumbericÊý¾Ý¡£
......

ÓÃÓÚ·ÖÒ³ÏÔʾµÄSQLÎÄ

Ô­Ö· http://technet.microsoft.com/ja-jp/library/cc411406.aspx
 
¿´ÁËһƪSQL2005¹ØÓÚTransact-SQLµÄÇ¿»¯¼¼ÄܵĽéÉÜ£¬¾õµÃºÜÓÐÓô¦£¬¼òµ¥×ܽáÁËһϡ£
 
£¨Ò»£©Êý¾Ý¿â×ö³É
USE tempdb – »òÕßн¨Ò»¸öDB
CREATE TABLE SpeakerStats
(
  speaker      &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ