SQL server 2005»ùÓÚÒÑ´æÔÚµÄ±í´´½¨·ÖÇø
< type="text/javascript">
< type="text/javascript">
Èç×ªÔØ£¬Çë×¢Ã÷³ö´¦£ºhttp://blog.csdn.net/robinson_0612/archive/2009/11/07/4783702.aspx
Ëæ×ŵ±½ñÊý¾Ý¿âµÄÈÝÁ¿Ô½À´Ô½¿ìµÄ³¯×ÅÔÚ´óÐÍÊý¾Ý¿â»ò³¬´óÐÍÊý¾Ý¿âµÄ·¢Õ¹£¬¶ÔÓÚÊý¾Ý¿âÖеĴóÐͱíÒÔ¼°¾ßÓи÷ÖÖ·ÃÎÊģʽµÄ±íµÄ¿ÉÉìËõÐԺͿɹÜÀíÐÔÔËÐл·¾³±äµÃ
ÓÈÎªÖØÒª£¬SQL server´ÓSQL server 7.0µÄ·ÖÇøÊÓͼµ½SQL server 2000ÖеķÖÇøÊÓͼÖе½SQL server
2005ËùʹÓõķÖÇø±í£¬²»¶Ï¸ÄÉÆ´óÐͱíËùÃæÁÙµÄÐÔÄÜ¡¢×èÈû¡¢±¸·Ý¿Õ¼ä¡¢Ê±¼ä¡¢ÔËÓª³É±¾µÈ¡£µ±±íºÍË÷Òý·Ç³£´óµÄʱºò£¬Í¨¹ý·ÖÇø±íµÄʵÏÖ£¬¿ÉÒÔ½«Êý¾Ý·ÖΪ¸ü
С£¬¸üÒ×ÓÚ¹ÜÀí£¬»ñµÃ¸üºÃµÄ¿É²Ù×÷ÐÔÄÜ¡£±¾ÊµÑé½éÉÜ»ùÓÚÒÑ´æÔڵıíÀ´ÈçºÎ´´½¨·ÖÇø£¬¹ÜÀí·ÖÇø¡£
Ò»¡¢ÊµÑéÄ¿µÄ£º¶ÔÓÚÒѾ´æÔڵıíÇÒ²»¶ÏÔö´óµÄÇé¿öϹ¹½¨·ÖÇø±í£¬¹ÜÀí·ÖÇø±í£¬Ìá¸ßÆäÐÔÄÜ¡£
¶þ¡¢Ö÷Òª²½Ö裺¶ÔÓÚÒѾ´æÔÚµÄ±í£¬ÎÒÃÇ¿ÉÒÔ²ÉÈ¡ÒÔϲ½ÖèÀ´¶ÔÆä´´½¨·ÖÇø±í
1.´´½¨·ÖÇøº¯Êý
2.´´½¨·ÖÇø¼Ü¹¹²¢¹ØÁªµ½·ÖÇøº¯Êý
3.ɾ³ýÒѾ´æÔڵľۼ¯Ë÷Òý
4.»ùÓÚ·ÖÇø¼Ü¹¹Öؽ¨¾Û¼¯Ë÷Òý
Èý¡¢ÊµÑé»·¾³£º
1. windows xp pro (Ó¢Îİæ) + sp2
2. SQL server 2005 Developer + sp3
3.ʵÑéÊý¾Ý¿âPerformance,´ËÊý¾Ý¿â²ÎÕÕʵÑé¶þ£ºSQL server 2005¸ß¿ÉÓÃÐÔÖ®----Êý¾Ý¿â¾µÏñ
ÖеÄÉú³É½Å±¾Éú³ÉÊý¾Ý¿â£¬±¾ÊµÑé¶ÔÆäÊý¾Ý¿âµÄ´æ·Å×öÁ˵÷Õû£¬½«Êý¾ÝºÍÈÕÖ¾Îļþ´æ·ÅÔÚD:\SQL_Data\PerformanceĿ¼Ï¡£
4.¶ÔÒÑ´æÔÚÒª´´½¨µÄ·ÖÇø±íΪ£ºPerformanceÊý¾Ý¿âϵÄOrders±í.
5.¶ÔOrders±íÖеÄorderdateÁа´Äê½øÐÐˮƽ·ÖÇø
ËÄ¡¢¾ßÌåÊÔÑé²½Ö裺
1.´´½¨·ÖÇøº¯Êý
È·¶¨·ÖÇøµÄÊýÄ¿¼°·ÖÇøµÄÁУ¬ÁеÄÊý¾ÝÀàÐÍ¡£±¾Àý½«Orders±íµÄorderdate°´Äê·Ýˮƽ·ÖÎå¸öÇø£¬ÔòÐèÒª¶¨ÒåËĸö±ß½çµãÖµ¡£ÈçÏ£¬
use Performance;
go
Create partition function
Part_func_orders(datetime) as
range left
for values('20021231 23:59:59.997',
'20031231 23:59:59.997',
&nb
Ïà¹ØÎĵµ£º
SQL×¢Èëʽ¹¥»÷ÊÇÀûÓÃÊÇÖ¸ÀûÓÃÉè¼ÆÉϵÄ©¶´£¬ÔÚÄ¿±ê·þÎñÆ÷ÉÏÔËÐÐSqlÃüÁîÒÔ¼°½øÐÐÆäËû·½Ê½µÄ¹¥»÷¶¯Ì¬Éú³ÉSqlÃüÁîʱûÓжÔÓû§ÊäÈëµÄÊý¾Ý½øÐÐÑéÖ¤ÊÇSql×¢Èë¹¥»÷µÃ³ÑµÄÖ÷ÒªÔÒò¡£
±ÈÈ磺
Èç¹ûÄãµÄ²éѯÓï¾äÊÇselect * from admin where username="&user&" and password="&pwd&""
ÄÇô£¬Èç¹ûÎÒµÄÓû§ÃûÊ ......
±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁУ¬[ID] int IDENTITY (1,1)
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³)
Óï¾äÐÎʽ£º
SELECT TOP Ò³¼Ç¼ÊýÁ¿ *
from ±íÃû
WHERE (ID NOT IN
(SELECT TOP (ÿҳÐÐÊý*(Ò³Êý-1)) ID
from ±íÃû
ORDER BY ID))
ORDER BY ID
//×Ô¼º»¹¿ÉÒÔ¼ÓÉÏһЩ²éѯÌõ¼þ
Àý:
sele ......
ÊÖ¶¯ÉèÖüÆÊýÆ÷×¢²á±íÏîµÄÔöÁ¿ :
1.ÔÚ Microsoft Windows 2003 »ò Windows XP ×ÀÃæÉÏ£¬ÒÀ´Îµ¥»÷“¿ªÊ¼”¡¢“ÔËÐД£¬È»ºóÔÚ“´ò¿ª”ÖмüÈë regedit.exe£¬ÔÙµ¥»÷“È·¶¨”¡£ÔÚ Windows 2000 ÖУ¬Ê¹Óà regedt32.exe Æô¶¯×¢²á±í±à¼Æ÷¡£
  ......
½ñÌìÊÔÑéʹÓÃpythonÁ¬½Ó sql server ·þÎñÆ÷¡£ÎҼǵÃÒÔǰʹÓÃadoÁ¬½Óaccess·Ç³£Ë³Àû£¬µ«ÊǽñÌìʹÓÃadoÁ¬½Ósql server¾¹È»²»³É¹¦¡£ÔÚpythonÀïÃæµÄ³ö´íÐÅÏ¢¶¼ÏÔÊ¾Îª×ªÒÆÐòÁУ¬·ÑÁ˰ëÌì¾¢²Å¸ãÃ÷°×£ºÎÞЧµÄÀà±ð×Ö·û´®¡£
ÊÇÁ¬½Ó×Ö·û´®Â𣿲âÊÔÁ˺ü¸¸ö È·ÈÏÎÞÎóµÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®£¬Ò²ÊÇÈç´Ë ¡£ÉÏÍøËÑË÷£¬ÊÇÓпÉÄÜÊÇ comµÄÀà±ð×Ö ......