ÍêÈ«Ð¶ÔØSQL Server 2005
SQL Server 2005£¨ÊÊÓÃÓÚ2000£©µÄÐ¶ÔØÊÇÒ»¸ö·Ç³£Í·ÌÛµÄÎÊÌâ¡£ÎÒÔø¾³¢ÊÔ¹ýÖ±½ÓʹÓá¾Ìí¼Ó»òɾ³ý³ÌÐò¡¿¹¤¾ßÐ¶ÔØ¡¢Çå³ý°²×°Ä¿Â¼¡¢É¾³ý×¢²á±íÄÚÈݵȵȸ÷ÖÖ·½Ê½×ÛºÏÐ¶ÔØ£¬ÃãÇ¿³É¹¦¡£ÏÖÔÚÖÕÓÚÕÒµ½ÁËÒ»¸öʰ빦±¶µÄ·½·¨£¬¶à´Î³¢ÊÔ£¬Î´ÓÐʧ°Ü,¾ßÌåÈçÏÂ:
1.ÏÂÔØÐ¶ÔØ¹¤¾ß£¬ÓÐÁ½ÖÖ£º
µÚÒ»ÖÖÊÇ΢Èí¹Ù·½ÌṩµÄ¹¤¾ß(msicuu2.exe)
http://support.microsoft.com/default.aspx?kbid=290301
µÚ¶þÖÖÊǸ÷´óÏÂÔØÍøÕ¾ÏÂÔØµÄ·Ç΢Èí¹Ù·½¹¤¾ß(SrvInstw.exe)
΢Èí¹Ù·½¹¤¾ßÐèÒª°²×°£¬¶øÇÒ°²×°²½Öè±È½ÏÂé·³£¬»¹ÓÐûÕÒµ½Ö§³Ö64λµÄ£»
·Ç΢Èí¹Ù·½¹¤¾ß´¿ÂÌÉ«£¬²»Ðè°²×°£¬Ö±½ÓÐ¶ÔØ£¬Ö§³Ö64λ¡£
ËùÒÔÎÒ»¹ÊÇϰ¹ßÓ÷Ç΢Èí¹Ù·½¹¤¾ß£¬¾õµÃºÃÓá£
2.ʹÓÃÐ¶ÔØ¹¤¾ßÐ¶ÔØËùÓÐSQL Server·þÎñºÍÏà¹Ø×é¼þ(×¢Òâ£ºÐ¶ÔØÇ°ÒªÏÈÍ£Ö¹¶ÔÓ¦µÄ·þÎñ£¬·ñÔò¿ÉÄÜÐ¶ÔØÊ§°Ü)
3.ɾ³ýC:\WINDOWS\inf ÏÂËùÓÃÎļþ(ÎÒÊÇÔÚ¸ÃÎļþ¼ÐÏÂËÑË÷“sqlserver”£¬È»ºóɾ³ýËùÓнá¹ûÎļþ)
¿ÉÄÜËÑË÷infÎļþ¼Ð£¬¸ù±¾Ã»ÓÐÈκÎÐÅÏ¢£¬ÄǾͲ»ÓÃɾÁË
4.ɾ³ýsql 2005°²×°Ä¿Â¼ÏµÄËùÓÐÎļþ
5.ɾ³ý×¢²á±íÖУº
°ÑHKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ Microsoft SQL Server
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVER AGENT
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services \MSSQLServerADHelper
È«²¿É¾µô£¬µ«ÊÇÒ»°ãÀ´Ëµ£¬Èç¹ûÓÃÁËÐ¶ÔØ¹¤¾ßÖ®ºó£¬×¢²á±íÖв»»áÓÐÕâЩÄÚÈÝÁË£¨ÎÒÓÃÁËSrvInstw.exeÖ®ºó¾Íû·¢ÏÖ×¢²á±íÖÐÓÐÒÔÉÏÄÚÈÝ£©
6.ʹÓÿØÖÆÃæ°åµÄ¡¾Ìí¼Ó»òɾ³ý³ÌÐò¡¿¹¤¾ß£¬²é¿´ÓÐÎÞÆäËûδɾ³ýµÄSQL Server³ÌÐò£¬ÈçÓж¼Ò»²¢É¾³ýµô
7.ÖØÆô¼ÆËã»ú
¼ÆËã»úÖØÆôÍê³Éºó£¬SQL Server 2005¾Í±»ÍêÈ«µÄÐ¶ÔØ¸É¾»ÁË£¬¿ÉÒÔÕý³£ÖØÐ°²×°¡£
Ïà¹ØÎĵµ£º
SQL³£Ó÷ÖÒ³µÄ°ì·¨:
±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁУ¬[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
//×Ô ......
select *from student
select student_id from student
select student_id ,student_name from student
select student_id student_name from student ½«student_name ×÷Ϊstudent_idµÄ±ðÃû´¦Àí
È磺 select student_id a from student
select a=student_id from student
´Óstudent±íÖзֱð¼ ......
Êý¾Ý¿âµÄÐÔÄܲâÊÔ¿ÉÒÔ°ïÖúÄãÌáǰ֪µÀÄãµÄϵͳµÄ¸ºÔØÄÜÁ¦£¬¿ÉÒÔ°ïÖúÄã¸Ä½øÏµÍ³µÄʵʩ»òÉè¼Æ£¬¿ÉÒÔ°ïÖúÄãÈ·¶¨Ò»Ð©Éè¼ÆºÍ±à³ÌÔÔò. µ«ÊÇ£¬ÕâÀïÃæÒ²ÓÐÏÝÚå. Èç¹û²»Ð¡ÐÄ£¬Äã»á×Ô¼º°Ñ×Ô¼ºÏݽøÈ¥£¬È´×îÖÕ²»Ã÷°×ÊÇʲôÔÒò. ÕâÀÎÒÄÃһλÏÈÉúΪÀý£¬À´¿´¿´ËûÔõô×Ô¼º°Ñ×Ô¼º¸ãºýÍ¿µÄ.
×î½ü, ÏëÆðÔÚ´æ´¢¹ý³ÌÖо¿¾¹ÊÇʹÓÃÁÙʱ±í»¹ÊÇÊ ......
×î½ü¿´µ½ºÜ¶àÈ˵ÄÍøÕ¾¶¼±»×¢Èëjs,±»iframeÖ®ÀàµÄ¡£·Ç³£¶à¡£
±¾ÈËÔø½ÓÊÖ¹ýÒ»¸ö±È½Ï´óµÄÍøÕ¾£¬±»È˼ÒÈëÇÖÁË£¬ÒªÎÒÊÕʰ²Ð¾Ö¡£¡£
1.Ê×ÏÈÎÒ»á¼ì²éһϷþÎñÆ÷ÅäÖã¬ÖØÐÂÅäÖÃÒ»´Î·þÎñÆ÷°²È«£¬¿ÉÒԲο¼
http://hi.baidu.com/zzxap/blog/item/18180000ff921516738b6564.html
2.Æä´Î£¬ÓÃÂó¿§·È×Ô¶¨Òå²ßÂÔ£¬¼´Ê¹ÍøÕ¾³ÌÐòÓЩ¶´ ......