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

SQLÒªÇóCDKEYµÄ½â¾ö°ì·¨

 
[¿ÉÓÃ]Èç¹û³öÏÖ°²×°sql server 2000ÒªÇóCD-KEYµÄÇé¿ö,ÇëʹÓÃregedt32ÕÒ¿ª×¢²á±í,ÔÚÒÔÏÂÖ÷¼ü[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager]Öн¨Á¢Ò»¸öDWORD¼ü
SafeDLLSearchMode²¢ÉèֵΪ0
Õâ¸öÊÔ¹ý£¬ÊÇ¿ÉÒÔÓõÄ
 
H6TWQ-TQQM8-HXJYG-D69F7-R84VM      -----2KSVRÐòÁкÅ
JCYFH-BYJMR-C4PVV-VD9G3-VXDYG        ----2003SVRÐòÁкÅ
windows 2003 server ÒÔǰ°æ±¾µÄ²Ù×÷ϵͳÉϺÃÏñ´ÓÀ´Ã»ÓгöÏÖ¹ýÒªÊäÈëCD KEY,µ«ÔÚwindows 2003 server´òÉÏSP1ºÍÓò¿ØÖÆÆ÷»·¾³ÏÂÈ´ÔÚ°²×°¹ý³ÌÖгöÏÖÊäÈëCDKEYµÄ½çÃæ,ÌáʾÌáʾÎÞ·¨ÑéÖ¤²úÆ·ÃÜÔ¿,CDKEY²»¶Ô?
½â¾ö°ì·¨ÈçÏ£º
»·¾³: windows 2003 server + SP1ÆóÒµVOL°æ Óò¿Ø»·¾³
°²×°Êý¾Ý¿â: SQL 2000
ÔÚ¸ø³öµÄÊäÈëCDKEYµÄ½çÃæÖУ¬ÊäÈëÄãÒѾ­°²×°µÄwindows server 2003 µÄCDKEY¼´¿ÉÒÔ¼ÌÐø°²×°£¬¶ø²»ÊÇSQL 2000µÄCDKEY¡£
Ï£ÍûÄܸøÓöµ½ÕâÖÖÎÊÌâµÄIT´ÓÒµÈËÔ±Ò»¸ö°ïÖú£¬×£Äã³É¹¦¡£
---------------
Èç¹û»¹²»ÐУ¬¿ÉÒԲο¼£º
ÔÚ Service Pack 4 (SP 4), ÊÇÔËÐÐ Microsoft Windows Server 2003¡¢ Microsoft Windows Storage Server 2003 »ò Microsoft Windows 2000 ·þÎñÆ÷ÉÏÄú³¢ÊÔ°²×° Microsoft SQL Server 2000 ͨ¹ý¾íÐí¿ÉЭÒé (VLA) ýÌå¡£ ÕâÑù×ö, ÊÕµ½ÒÔÏ´íÎóÐÅÏ¢CD KEYµÄ SQLServer °²×°Ïòµ¼Ò³ÉÏ£º
ÎÞ·¨ÑéÖ¤²úÆ·ÃÜÔ¿
½â¾ö·½°¸
Èç¹ûÕýÈ·ÐÞ¸Ä×¢²á±íͨ¹ýʹÓÃ×¢²á±í±à¼­Æ÷»òÕßͨ¹ýʹÓÃÆäËû·½·¨¾¯¸æ¿ÉÄÜ·¢Éú Serious ÎÊÌâ¡£ ÕâЩÎÊÌâ¿ÉÄÜÐèÒªÖØÐ°²×°²Ù×÷ϵͳ¡£ Microsoft ²»Äܱ£Ö¤¿ÉÒÔ½â¾öÕâЩÎÊÌâÁË¡£ ÐÞ¸Ä×¢²á±íÐèÒªÄú×Ôµ£·çÏÕ¡£
Òª½â¾ö´ËÎÊÌâ, Çë°´ÕÕÏÂÁв½Ö裺1. ÔÚ SQLServer °²×°Ïòµ¼, µ¥»÷È¡Ïû¡£
2. Æô¶¯×¢²á±í±à¼­Æ÷¡£ ÒªÕâÑù×ö, µ¥»÷¿ªÊ¼¡¢ÔËÐУ¬ ¼üÈëregedt 32, ºÍÈ»ºóÈ·¶¨¡£
3. ÕÒµ½²¢Ë«»÷SafeDllSearchMode×¢²á±íÏî¡£
ÔÚÔËÐÐ Windows Server 2003 ·þÎñÆ÷»ò´æ´¢ Windows Server 2003, ´Ë×¢²á±íÏîλÓÚÒÔÏÂ×¢²á±í×ÓÏîÏ£º
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager
ÔÚÔËÐдøÓÐ SP 4, Windows 2000 ·þÎñÆ÷´Ë×¢²á±íÏîλÓÚÒÔÏÂ×¢²á±í×ÓÏîÏ£º
HKEY_LOCAL_MACHINE\System\Control\Session Manager
×÷Ϊ DWORD Öµ×¢ÒâÈç¹û SafeDllSearchMode ×¢²á±íÏî²»´æÔÚ, ´´½¨ SafeDllSearchMode ×¢²á±íÏî¡£
4. ÔÚÊýÖµÊý¾Ý¿òÖÐ, ½«Öµ´Ó 1 ¸ü¸ÄΪ 0, È»ºóµ¥»÷È·¶¨¡£
5. Í˳ö×¢²


Ïà¹ØÎĵµ£º

Oracle ѧϰ£ºPL/SQLÑ­Ðò½¥½øÈ«ÃæÑ§Ï°½Ì³Ì

 ¡¡¿Î³ÌÎå ×Ó²éѯ
¡¡¡¡
¡¡¡¡±¾¿ÎÖØµã£º
¡¡¡¡1¡¢ÔÚÌõ¼þδ֪µÄÇé¿öϲÉÓÃǶÌ××Ó²éѯ
¡¡¡¡2¡¢ÓÃ×Ó²éѯ×öÊý¾Ý´¦Àí
¡¡¡¡3¡¢×Ó²éѯÅÅÐò
¡¡¡¡
¡¡¡¡×¢Ò⣺ÒÔÏÂʵÀýÖбêµã¾ùΪӢÎİë½Ç
¡¡¡¡
¡¡¡¡Ò»¡¢¸ÅÊö£º
¡¡¡¡×Ó²éѯÊÇÒ»ÖÖSELECT¾äʽÖеĸ߼¶ÌØÐÔ£¬¾ÍÊÇÒ»¸öSELECTÓï¾ä×÷ΪÁíÒ»¸öÓï¾äµÄÒ»¸ö¶Î¡£ÎÒÃÇ¿ÉÒÔÀûÓÃ×Ó²éѯÀ´ ......

SQL×¢Èëʽ¹¥»÷ʵÀý½²½â

 ¸Õ¸Õ¸ßÖеÄһλͬѧÎÊÎÒÒ»µÀ±ÊÊÔÌ⣺Çë¼òÊöSQL×¢Èëʽ¹¥»÷¼°ÆäÔ­Àí¡£
 
£¨Q£º¹¥»÷£¿ÄѵÀÊÇ×öºÚ¿ÉÂ𣿣¿£©
¿ÉÒÔ°ÑÕâÖÖÐÐΪÀí½â³ÉºÚ¿ÍÐо¶£¬ÒòΪÕâÑù×öµÄÄ¿µÄ¾ÍÊÇ¡°·Ç·¨»ñÈ¡¡±¡£
 
£¨Q£ºÔõô×ö£¿£©
¿ÉÒÔ°´ÕÕÎÒÏÂÃæµÄ²½ÖèÒ»²½Ò»²½À´£¬´ó¼ÒÒ²¾Íµ±Ò»»Ø¡°ºÚ¿Í¡±ÁË¡££¨P.S. Õâ¿ÉÊÇÎÒ¡°¶À¼ÒÑÐÖÆ¡± ......

½âÎöMicrosoft Sql ServerÖеÄlikeÓï¾ä


 
 
ʹÓà LIKE µÄģʽƥÅä
 
µ±ËÑË÷ datetime ֵʱ£¬ÍƼöʹÓà LIKE£¬ÒòΪ datetime Ïî¿ÉÄܰüº¬¸÷ÖÖÈÕÆÚ²¿·Ö¡£ÀýÈ磬Èç¹û½«Öµ 19981231 9:20 ²åÈëµ½ÃûΪ arrival_time µÄÁÐÖУ¬Ôò×Ó¾ä WHERE arrival_time = 9:20 ½«ÎÞ·¨ÕÒµ½ 9:20 ×Ö·û´®µÄ¾«È·Æ¥Å䣬ÒòΪ SQL Server ½«Æäת»»Îª 1900 Äê 1 Ô 1 ÈÕÉÏÎ ......

Microsoft SQL Server ¹ÜÀí £¨³£ÓùÜÀí¼°Î¬»¤ÃüÁ


--²éѯµ±Ç°Á¬½ÓµÄʵÀýÃû
select @@servername
--²ì¿´ÈκÎÊý¾Ý¿âÊôÐÔ
sp_helpdb master
--ÉèÖõ¥Óû§Ä£Ê½£¬Í¬Ê±Á¢¼´¶Ï¿ªËùÓÐÓû§
alter database Northwind set single_user with rollback immediate
--»Ö¸´Õý³£
alter database Northwind set multi_user
--²ì¿´Êý¾Ý¿âÊôÐÔ
sp_helpdb
--²ì¿´Êý¾Ý¿â»Ö¸´Ä£Ê½
sel ......

½ÓÉÏһƪÎÄÕ£¬µ¼³öÒ»¸ö±í£¬»òÕßÕû¸öÊý¾Ý¿âµ½SQLÐÎʽ

 <?php
 require_once '../../smartyConfig/smartyConfig.class.php';
 require_once '../../game/include/function.php';
 require_once '../../game/include/config.php';
 require_once '../../game/server/server.class.php';
 require_once '../../game/include/db.class.php'; ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ