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

t sql ¶Á³öÿ×éµÄǰn¸ö

http://topic.csdn.net/u/20100113/17/b52a1ef4-54a8-4333-8119-a161869c1eef.html
---------------------------------
--  Author: liangCK СÁº
--  Title : ²éÿ¸ö·Ö×éǰNÌõ¼Ç¼
--  Date  : 2008-11-13 17:19:23
---------------------------------
--> Éú³É²âÊÔÊý¾Ý: #T
IF OBJECT_ID('tempdb.dbo.#T') IS NOT NULL DROP TABLE #T
CREATE TABLE #T (ID VARCHAR(3),GID INT,Author VARCHAR(29),Title VARCHAR(39),Date DATETIME)
INSERT INTO #T
SELECT '001',1,'×Þ½¨','ÉîÈëdz³öSQLServer2005¿ª·¢¹ÜÀíÓëÓ¦ÓÃʵÀý','2008-05-10' UNION ALL
SELECT '002',1,'ºú°Ù¾´','SQLServer2005ÐÔÄܵ÷У','2008-03-22' UNION ALL
SELECT '003',1,'¸ñÂÞ·òGroff.J.R.','SQLÍêÈ«ÊÖ²á','2009-07-01' UNION ALL
SELECT '004',1,'KalenDelaney','SQLServer2005¼¼ÊõÄÚÄ»´æ´¢ÒýÇæ','2008-08-01' UNION ALL
SELECT '005',2,'Alex.Kriegel.Boris.M.Trukhnov','SQL±¦µä','2007-10-05' UNION ALL
SELECT '006',2,'·É˼¿Æ¼¼²úÆ·Ñз¢ÖÐÐÄ','SQLServer2000¸ß¼¶¹ÜÀíÓ뿪·¢','2007-09-10' UNION ALL
SELECT '007',2,'ºú°Ù¾´','SQLServer2005Êý¾Ý¿â¿ª·¢Ïê½â','2008-06-15' UNION ALL
SELECT '008',3,'³ÂºÆ¿ü','SQLServer2000´æ´¢¹ý³ÌÓëXML±à³Ì','2005-09-01' UNION ALL
SELECT '009',3,'ÕÔËÉÌÎ','SQLServer2005ϵͳ¹ÜÀíʵ¼','2008-10-01' UNION ALL
SELECT '010',3,'»ÆÕ¼ÌÎ','SQL¼¼ÊõÊÖ²á','2006-01-01'
--SQL²éѯÈçÏÂ:
--°´GID·Ö×é,²éÿ¸ö·Ö×éÖÐDate×îеÄǰ2Ìõ¼Ç¼
--1.×Ö¶ÎIDΨһʱ:
SELECT * from #T AS T WHERE ID IN(SELECT TOP 2 ID from #T WHERE GID=T.GID ORDER BY Date DESC)
--2.Èç¹ûID²»Î¨Ò»Ê±:
SELECT * from #T AS T WHERE 2>(SELECT COUNT(*) from #T WHERE GID=T.GID AND Date>T.Date)
--SQL Server 2005 ʹÓÃз½·¨
--3.ʹÓÃROW_NUMBER()½øÐÐÅÅλ·Ö×é
SELECT ID,GID,Author,Title,Date
from
(
   SELECT rid=ROW_NUMBER() OVER(PARTITION BY GID ORDER BY Date DESC),*
   from #T
) AS T
WHERE rid<=2
--4.ʹÓÃAPPLY
SELECT DISTINCT b.*
from #T AS a
CROSS APPLY
(
    SELECT TOP(2) * from #T WHERE a.GID=GID ORDER BY Date DESC
) AS b
--½á¹û
/*
ID   GID         Author &


Ïà¹ØÎĵµ£º

SQL SERVER 2000 "MMCÎÞ·¨´´½¨¹ÜÀíµ¥Ôª

·½°¸Ò» ÔËÐÐmmc£¬È»ºó²Ù×÷£¬¿ØÖÆÌ¨–Ìí¼Ó/ɾ³ý¹ÜÀíµ¥Ôª–Ìí¼Ó–ÕÒµ½Microsoft SQL ÆóÒµ¹ÜÀíÆ÷–Ìí¼Ó–¹Ø±Õ–È·¶¨£¨×¢£º´Ë´¦µã»÷Ìí¼ÓÍêºó¾Í¿ÉÒԹرÕÁË£¬²»ÒªµÈ´ýÏìÓ¦£¬Èç¹ûÄã¶à´Îµã»÷ÁËÌí¼Ó£¬ºóÀ´¿ÉÒÔ¿´µ½n¶à¸ösqlÆóÒµ¹ÜÀíÆ÷¡£¡£¡££©£¬Ôٻص½¿ØÖÆÌ¨–Ñ¡Ïî–¿ØÖÆÌ¨Ä£Ê½Ñ¡Ôñ”Óà ......

¾­µäSQLÓï¾ä´óÈ«(ÊʺÏSQL SERVER)


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

SQL Server´´½¨ÊÓͼ

2009-10-08 16:05
ʲôÊÇÊÓͼ
     ´ó¼Ò¶¼ÖªµÀ£¬ÎÒÃǹú¼ÒÏÖÔÚ“ÉñÆß”ÉÏÌìÁË¡£´ÓÃÀ¹úµÄÔÂÇòµÇÔ¿ªÊ¼£¬ÈËÀàÉÏÌì²»ÔÙÊÇÉñ»°¡£Ìý˵£¬ÔÚÃÀ¹ú£¬ÄãÖ»Òª³ö¼¸Ê®ÍòÃÀÔª£¬Äú¾Í¿ÉÒÔÉÏÒ»´ÎÔÂÇò½øÐÐÌ«¿ÕÂÃÐУ¬ËùÒÔ£¬ÎÒÃÇÏàÐÅ£ºÔÚ²»¾ÃµÄ½«À´£¬ÉÏÌìÂÃÐн«×ß½øÎÒÃǰÙÐÕµÄÉú»î£¬ÄÇÊÇÒ»¼þ¶àôÐÂÏÊÉñÆæµÄÊÂÇé° ......

SQL ServerµÄ ÅÅÐò¹æÔò(collation)³åÍ»ºÍ½â¾ö·½°¸

ʲôÊÇÅÅÐò¹æÔò£¨collation£©
¹ØÓÚSQL ServerµÄÅÅÐò¹æÔò£¬¹À¼Æ´ó¼Ò¶¼²»Ä°Éú£¬ÔÚ´´½¨Êý¾Ý¿âʱÎÒÃǾ­³£ÒªÑ¡ÔñÒ»ÖÖÅÅÐò¹æÔò£¨conllation£©£¬Ò»°ãÎÒÃÇ»áÁôÒ⵽ÿһÖÖÓïÑÔµÄÅÅÐò¹æÔò¶¼ÓÐÐí¶àÖÖ£¬±ÈÈç±ê×¼´ó½¼òÌåÖÐÎÄChinese_PRCµÄÅÅÐò¹æÔò¾ÍÓÐÊýÊ®ÖÖÖ®¶à

ÕâЩÅÅÐò¹æÔòÓÐʲô×÷ÓÃÄØ£¿ÈÃÎÒÃÇÏÈÀ´¿´¿´MS¹Ù·½µÄ½âÊÍ£º
ÅÅÐò¹æÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ