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

SQLServerÖÐÎÄ´¦Àí

Ê×ÏȲå¾äÌâÍâ»°£º´´½¨Ò»¸ö×ÔÈ»Êý±íNums¡£ÕâÊÇ¡¶SQL Server 2005¼¼ÊõÄÚÄ»£ºT-SQL²éѯ¡·Ò»ÊéµÄ½¨Òé¡£
ÔÚSQL Server 2005ÖУ¬¿ÉÒÔ½èÓÃROW_NUMBERÅÅÃûº¯ÊýÇáËÉÉú³ÉÎÒÃÇËùÐèµÄ×ÔÈ»Êý±í£º
--×ÔÈ»Êý±í1-1M
CREATE TABLE Nums(n int NOT NULL PRIMARY KEY CLUSTERED)
WITH B1 AS(SELECT n=1 UNION ALL SELECT n=1), --2
B2 AS(SELECT n=1 from B1 a CROSS JOIN B1 b), --4
B3 AS(SELECT n=1 from B2 a CROSS JOIN B2 b), --16
B4 AS(SELECT n=1 from B3 a CROSS JOIN B3 b), --256
B5 AS(SELECT n=1 from B4 a CROSS JOIN B4 b), --65536
CTE AS(SELECT r=ROW_NUMBER() OVER(ORDER BY (SELECT 1)) from B5 a CROSS JOIN B3 b) --65536 * 16
INSERT INTO Nums(n)
SELECT TOP(1000000) r from CTE ORDER BY r
ÒÔÉÏÓï¾äÉú³ÉÇ°100Íò¸ö×ÔÈ»Êý¡£
ÒÔÏ¿ªÊ¼ÕýÌâ¡£
Ò»¡¢×Ö·û±àÂëÓëÅÅÐò¹æÔò
×ö¹ýWeb¿ª·¢µÄÈ˶Ô×Ö·û±àÂëÒ»¶¨²»Ä°Éú¡£¼òµ¥À´Ëµ£¬ÈËËùÄܹ»Ê¶±ðµÄ×Ö·ûÈç“A”¡¢“Ò»”Óë¼ÆËã»úÄÚ²¿²Ù×÷µÄÊý×Ö01000001¡¢1101001010111011ÊDz»Ò»ÑùµÄ£¬ÐèÒª½¨Á¢Ò»ÖÖ¶ÔÓ¦¹ØϵÀ´ÈüÆËã»úÄܹ»“ʶ±ð”ÈËÃÇËùʹÓõÄ×Ö·û£¨»òÕß˵ÊÇÈÃÈËÃÇÄܹ»ÓÃ×Ô¼ºÏ°¹ßµÄ·½Ê½Ê¶±ð¼ÆËã»ú²Ù×÷µÄÊý×Ö£©£¬×Ö·û±àÂë¾ÍÊÇÕâ¸ö¶ÔÓ¦¹Øϵ¡£
¶ÔÓÚÓ¢ÓïÀ´Ëµ£¬´óСд×Öĸ¼ÓÊý×Ö¼Ó±êµã·ûºÅ£¬×ܹ²Ò²²»»á³¬¹ý128¸ö£¬Ò»¸ö×ֽھ͹»ÓÃÁË£»ASCII±àÂëֻʹÓÃÁËÒ»¸ö×Ö½ÚÖеÄ7룬±ãÒѾ­°üÀ¨ÁËÓ¢Óï³£ÓÃ×Ö·û£¬»¹¼ÓÉÏÁËÒ»×éµç´«´ò×Ö»úʱ´úµÄ¿ØÖÆ×Ö·û£¨ÖÁ½ñÈÔÔÚʹÓÃÆäÖм¸¸ö£©¡£
È»¶øÊÀÉϲ¢²»½öÓÐÓ¢ÓŷÖÞһЩÓïÑÔÐèҪʹÓõÄһЩÖØÒô×Ö·û²¢Ã»ÓаüÀ¨ÔÚASCII±àÂëÖУ»¶øÑÇÖÞµÄCJK£¨Ö¸China+Japan+Korea£©ÓïÑÔ×Ö·û¶à´ï¼¸Íò¸ö£¬¸üÊÇÔ¶Ô¶³¬¹ýÁËÒ»¸ö×Ö½ÚËùÄܱíʾµÄ·¶Î§£»ÔÙ¼ÓÉÏ°¢À­²®Óϣ²®À´ÓïµÈµÈ……
½â¾ö°ì·¨×ÔÈ»ÊÇÀ©³ä×Ö·û±àÂëλÊý¡£Ë«×Ö½Ú¿ÉÒÔ±íʾ65536¸ö×Ö·û£¬Í¨³£Çé¿öÏÂÊÇ×ã¹»ÁË¡£µ«ÕâʱÓÖÓÐÒ»¸öеÄÎÊÌ⣺µ±¼ÆËã»ú¶Áµ½Á½¸öÁ¬ÐøµÄ×Ö½Ú£¬ËüÓ¦¸Ã½«Ö®Àí½âΪÁ½¸öµ¥¶ÀµÄ×Ö·û»¹ÊÇÒ»¸ö×Ö·û£¿±àÂë·½°¸ÐèÒª½â¾öÕâ¸öÎÊÌâ¡£
µÚÒ»ÖÖ·½°¸ÊÇ΢ÈíÒýÈëµÄ´úÂëÒ³µÄ¸ÅÄî¡£ASCIIֻʹÓÃÁËÒ»¸ö×Ö½ÚµÄ7룬×Ö½Ú×î¸ßλÊÇ0£¬ÄÇô¿ÉÒÔÓÃ×î¸ßλÊÇ1µÄ·¶Î§À´±íʾÀ©Õ¹×Ö·û¡£¶ÔÓÚ¶àÊýÅ·ÖÞÓïÑÔ£¬Ò»¸ö×Ö½ÚµÄ256¸ö×Ö·ûÒÑÈ»×ã¹»£¬ÄÇô±ãÓÃ×Ö½Ú×î¸ßλÊÇ1µÄ128¸ö×Ö·ûÀ´±íʾÈçÖØÒô×Ö·û¡¢ÖƱí·ûµÈÀ©Õ¹×Ö·û£»¶ÔÓÚÑÇÖÞÓïÑÔ£¬Ê¹ÓÃÁ½¸öÁ¬ÐøµÄ×î¸ßλÊÇ1µÄ×Ö½ÚÀ´±íʾCJK×Ö·û£¬ÕâÑù£¬µ±¼ÆËã»ú¶Áµ½Ò»¸ö×î¸ßλÊÇ0µ


Ïà¹ØÎĵµ£º

ÔÚ²»Í¬sqlserver·þÎñÆ÷¼ä£¬´´½¨ÏàͬÊý¾Ý¿â¶ÔÏó¡£

·ÖÁ½ÖÖÇé¿ö£º
1¡¢Í¨¹ý½Å±¾·½Ê½£¬2¡¢µ¼Èëµ¼³ö·½Ê½
µ«²»Í¬°æ±¾µÄSqlServer,ÔÚÕâ·½Ãæ²¢²»Ïàͬ¡£
sql2000¶ÔÊý¾Ý¿â¶ÔÏóÖ´ÐÐÉú³É½Å±¾Ê±£¬¾¡¹Ü¶¼Ñ¡Éϸ÷¸öÌõ¼þ£¬µ«¶ÔÓÚ±í¶ÔÏó²¢²»ÄÜ´´½¨Ö÷¼ü
¿ÉÒÔͨ¹ýµ¼Èëµ¼³ö·½Ê½£¬ÔÚµ¼ÈëÄ¿±êÑ¡ÔñÄ¿±êsqlserverºó£¬Ñ¡ÔñÖ»µ¼³ö¶ÔÏó½á¹¹¾ÍºÃÁË¡£
sql2005¶ÔÊý¾Ý¿â¶ÔÏóÖ´ÐÐÉú³É½Å±¾Ê±£¬¿ÉÒÔ´´½¨Ö÷¼ ......

Microsoft SqlServer 2005 ͨÓ÷ÖÒ³ ´æ´¢¹ý³Ì

±¾À´ÎÒÊDz»ÔÞ³ÉʹÓÃͨÓô洢¹ý³ÌµÄ£¬Ö÷ÒªÊÇÒòΪ¸ù¾Ý±í½á¹¹À´¶¨ÖÆ·ÖÒ³²éѯ²»Óö¯Ì¬µÄÆ´SQL£¬ÕâÑù²ÅÊÇÕæÕýµÄ¸ßЧ£¬¶øÇÒֻҪд¹ýÒ»¸ö£¬ÄÇôÔÙÓÐÐÂÐèÇóµÄʱºò£¬Ð¡·¶Î§¸Ä¶¯¼¸´¦¾ÍokÁË¡£
µ«×ÜÊÇÓÐÈËÏòÎÒÌÖÒª»òÕßÌÖÂÛͨÓô洢¹ý³Ì£¬Ã»°ì·¨£¬±»±ÆÎÞÄΣ¬Á¼ÐÄÉ¥ÓëÀ§¾³¡£
ľÓÐÕÒµ½T-SQL´úÂë±à¼­Æ÷
-- ============================= ......

sqlserver FOR XML PATH Óï¾äµÄÓ¦ÓÃ

´úÂëÈçÏÂ:

DECLARE
@TempTable table(UserID int , UserName nvarchar(50));
insert into
@TempTable (UserID,UserName) values (1,'a')
insert into @TempTable
(UserID,UserName) values (2,'b')

select UserID,UserName
from @TempTable FOR XML PATH
ÔËÐÐÕâ¶Î½Å±¾£¬½«Éú³ÉÈçϽá¹û£º
¸´ÖÆ´úÂë ......

SQLSERVERÓû§È¨ÏÞ¹ÜÀíÊý¾Ý¿â

Óû§È¨ÏÞ¹ÜÀí
Ò»¡¢·þÎñÆ÷µÇ¼ÕʺźÍÓû§ÕʺŹÜÀí
1.SQL Server·þÎñÆ÷µÇ¼¹ÜÀí
²»¹ÜʹÓÃÄÄÖÖÈÏ֤ģʽ£¬Óû§¶¼±ØÐëÏȾ߱¸ÓÐЧµÄÓû§µÇ¼Õʺš£SQL ServerÓÐÈý¸öĬÈϵÄÓû§µÇ¼Õʺţº¼´sa¡¢Builtin\administratorsºÍguest¡£saÊÇϵͳ¹ÜÀíÔ±(system administrator)µÄ¼ò³Æ£¬ÊÇÒ»¸öÌØÊâµÄÓû§£¬ÔÚSQL ServerϵͳºÍËùÓÐÊý¾Ý¿âÖÐÓ ......

SQLSERVER¾Û¼¯Ë÷ÒýÓë·Ç¾Û¼¯Ë÷Òý£¨×ª£©

΢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý)ºÍ·Ç¾Û¼¯Ë÷Òý(nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý)……
(Ò»)ÉîÈëdz³öÀí½âË÷Òý½á¹¹
ʵ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ