ÈçºÎÐ¶ÔØSQL Server 2005
Ð¶ÔØSQL Server 2005µÄ·½·¨Ö®Ò»£¬·ÅÔÚÕâ¶ùÖ»ÊÇΪÁ˼Çס£º
1£º°ÑSQL Server2005µÄ°²×°ÅÌ£¨°²×°Îļþ£©·ÅÈëµ½¹âÇý¡£
2£º´ò¿ªÈçÏ·¾¶£º¿ªÊ¼/ÔËÐУ¬ÊäÈ룺cmd
3£ºÊäÈëÏÂÁÐÃüÁ
Start /wait \setup.exe /qb REMOVE=ALL INSTANCENAME=£º¹ÜÇøÅÌ·û£¬ÀýÈ磺G£º¡¢H£ºµÈ£»£º°²×°µÄSQLServerʵÀýÃû³Æ£¬Ä¬ÈÏֵΪ£º¹¦ÄÜ£ºÐ¶ÔØSQL Server 2005 ²¿¼þ¡£
4£ºÊäÈëÏÂÁÐÃüÁStart /wait msiexec /qb /X \Setup\sqlncli.msiµÄ½âÊÍÈçÉÏ¡£¹¦ÄÜ£ºÐ¶ÔØMicrosoft SQL Native Client¡£
5£ºÊäÈëÏÂÁÐÃüÁStart /wait \redist\2.0\dotnetfx.exe /q:a /c:"install /qu"ÈçÉÏ¡£¹¦ÄÜ£ºÐ¶ÔØMicrosoft .NET Framework¡£
´ÓSQL Server 2005 ExpressÉý¼¶¶øÀ´µÄʵÀý£¬ÓÃÆðÀ´×ܸоõ¹Ö¹ÖµÄ£¬ºÜ¶à¹¦ÄܺÃÏñ¶¼Í£ÁôÔÚExpress°æ±¾ÉÏ¡£Òò´ËÏë°ÑSQL Server 2005ÍêÈ«Ð¶ÔØºóÔÙ֨װ¡£
²Î¿¼ÎÄÕ£ºÈçºÎÊÖ¶¯Ð¶ÔØ SQL Server 2005 ʵÀý£¬ ´íÎó´úÂë-2147024893
²½Öè 1£ºÈ·±£ Microsoft SQL Server °²×°Ö§³ÖÎļþ×é¼þÒѰ²×°
ÔÚ“Ìí¼Ó»òɾ³ý³ÌÐò”ÖУ¬È·±£“Microsoft SQL Server °²×°Ö§³ÖÎļþ”³öÏÖÔÚÒѰ²×°µÄ³ÌÐòÁбíÖС£Èç¹û“Microsoft SQL Server °²×°Ö§³ÖÎļþ”³öÏÖÔÚ¸ÃÁбíÖУ¬Çëתµ½“²½Öè 2£ºÔËÐÐÃüÁîÒÔÐ¶ÔØ SQL Server ×é¼þ”Ò»½Ú¡£
Èç¹û“Microsoft SQL Server °²×°Ö§³ÖÎļþ”ûÓгöÏÖÔÚ¸ÃÁбíÖУ¬ÇëÏȰ²×°¸Ã×é¼þ£¬È»ºóÔÙ¼ÌÐø¡£Òª°²×°¸Ã×é¼þ£¬Çë°´ÕÕÏÂÁв½Öè²Ù×÷£º
ÕÒµ½ÔʼµÄ SQL Server 2005 °²×°½éÖÊ¡£
Òª°²×°Ö§³ÖÎļþ£¬ÇëË«»÷“Servers\setup\sqlsupport.msi”Îļþ¡£
×¢Ò⣺ÔÚ“²½Öè 5£ºÐ¶ÔØ Microsoft SQL Server °²×°Ö§³ÖÎļþ×é¼þ”Ò»½ÚÖУ¬½«Ð¶ÔظÃ×é¼þ¡£
²½Öè 2£ºÔËÐÐÃüÁîÒÔÐ¶ÔØ SQL Server ×é¼þ
×¢Òâ£ºÐ¶ÔØReporting Servicesʱ¿ÉÄܳöÏÖµÄÎÊÌ⣬°²×°³ÌÐòÎÞ·¨¶ÁÈ¡ IIsMimeMap ±í
½â¾ö·½·¨
1.Í£Ö¹IIS Admin·þÎñºÍWord Wide Web Publishing·þÎñ
2.½«IIS AdminµÄÆô¶¯ÀàÐ͸ÄΪ“½ûÓÔ£¨²»È»µÄ»°£¬Ð¶Ôعý³ÌIIS Admin»á±»Ð¶ÔسÌÐòÆô¶¯ÆðÀ´£¬»¹»á³öÏÖͬÑùµÄÎÊÌ⣩
ÔÚÃüÁîÌáʾ·ûÏ£¬ÔËÐÐÏÂÃæµÄÃüÁ
"%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe /Remove"
¹´Ñ¡ÄãҪɾ³ýµÄ×é¼þ¡£
×¢Ò⣺“Ìí¼Ó»òɾ³ý³ÌÐò”»¹»áʹÓÓ/Remove”Ñ¡ÏîÔËÐÐ ARPWrapper.exe ³ÌÐ
Ïà¹ØÎĵµ£º
Ò»¡¢Ê²Ã´ÊÇSQL×¢Èëʽ¹¥»÷£¿
ËùνSQL×¢Èëʽ¹¥»÷£¬¾ÍÊǹ¥»÷Õß°ÑSQLÃüÁî²åÈëµ½Web±íµ¥µÄÊäÈëÓò»òÒ³ÃæÇëÇóµÄ²éѯ×Ö·û´®£¬ÆÛÆ·þÎñÆ÷Ö´ÐжñÒâµÄSQLÃüÁî¡£ÔÚijЩ±íµ¥ÖУ¬Óû§ÊäÈëµÄÄÚÈÝÖ±½ÓÓÃÀ´¹¹Ô죨»òÕßÓ°Ï죩¶¯Ì¬SQLÃüÁ»ò×÷Ϊ´æ´¢¹ý³ÌµÄÊäÈë²ÎÊý£¬ÕâÀà±íµ¥ÌرðÈÝÒ×Êܵ½SQL×¢Èëʽ¹¥»÷¡£³£¼ûµÄSQL×¢Èëʽ¹¥»÷¹ý³ÌÀàÈ磺
¢Å ......
Ò»¡¢±íµÄµ¼Èëµ¼³öÓï¾ä¼°Ê±¼ä×Ö·û´®²¿·Ö´¦Àíº¯Êý
µ¼³öÊý¾Ý¿âËùÓбíµÄ½á¹¹ mysqldump -uroot -proot db_name -d > d:/export_db.sql(½áβ²»Ó÷ֺÅ)
µ¼³öÊý¾Ý¿âij¸ö±íµÄ½á¹¹ mysqldump -uroot -proot db_n ......
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
ÀýÈ磺ÏòÈÕÆÚ¼ÓÉÏ2Ìì
&nbs ......
1. ËÀËøÔÀí
¸ù¾Ý²Ù×÷ϵͳÖе͍Ò壺ËÀËøÊÇÖ¸ÔÚÒ»×é½ø³ÌÖеĸ÷¸ö½ø³Ì¾ùÕ¼Óв»»áÊͷŵÄ×ÊÔ´£¬µ«Òò»¥ÏàÉêÇë±»ÆäËû½ø³ÌËùÕ¾Óò»»áÊͷŵÄ×ÊÔ´¶ø´¦ÓÚµÄÒ»ÖÖÓÀ¾ÃµÈ´ý״̬¡£
ËÀËøµÄËĸö±ØÒªÌõ¼þ£º
»¥³âÌõ¼þ(Mutual exclusion)£º×ÊÔ´²»Äܱ»¹²Ïí£¬Ö»ÄÜÓÉÒ»¸ö½ø³ÌʹÓá£
ÇëÇóÓë±£³ÖÌõ¼þ(Ho ......