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

ÈçºÎ³¹µ×ɾ³ýSQL Server2005

1.Stop ËùÓзþÎñ
 
2.Óà Windows Install Clean Up ¹¤¾ßÐ¶ÔØSQL 2005×é¼þ
 
3.ÓÃSrvInstw.exeɾ³ýËùÓÐSQL·þÎñ
 
4.Çå³ý×¢²á±í
   a. ½«HKEY_CURRENT_USER---Software----MicrosoftϵÄMicrosoft SQL ServerÎļþ¼ÐÈ«²¿É¾³ý
   b. ½«HKEY_LOCAL_mACHINE---SOFTWARE---MicrosoftϵÄMicrosoft SQL Native Client ,Microsoft SQL Server, Microsoft SQL Server 2005 RedistÈ«²¿É¾³ý¡£
5.ɾ³ý²ÐÁôÎļþ
½«CÅÌ——Program FileϵÄMicrosoft SQL Server Îļþ¼Ðɾ³ý¡£
6.ÖØÆôµçÄÔ£¬ÖØÐ°²×°¡£
 
 
===============================================================================
 
»òÕß
http://blog.csdn.net/limeiyu/archive/2008/09/02/2868424.aspx
 
 
 
 


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......

SQL´æ´¢¹ý³Ìѧϰ


¡¡¡¡±¾ÎÄ´ÓSQL´æ´¢¹ý³ÌµÄ¸ÅÄÓŵ㣬Óï·¨£¬´´½¨¼¼ÇÉ£¬µ÷ÓÃµÈ¶à·½Ãæ½éÉÜÁËSQL´æ´¢¹ý³Ì¡£
¡¡¡¡Ò»¡¢SQL´æ´¢¹ý³ÌµÄ¸ÅÄÓŵ㼰Óï·¨
¡¡¡¡¡¡¶¨Ò壺½«³£ÓõĻòºÜ¸´ÔӵŤ×÷£¬Ô¤ÏÈÓÃSQLÓï¾äдºÃ²¢ÓÃÒ»¸öÖ¸¶¨µÄÃû³Æ´æ´¢ÆðÀ´, ÄÇôÒÔºóÒª½ÐÊý¾Ý¿âÌṩÓëÒѶ¨ÒåºÃµÄ´æ´¢¹ý³ÌµÄ¹¦ÄÜÏàͬµÄ·þÎñʱ,Ö»Ðèµ÷ÓÃexecute,¼´¿É×Ô¶¯Íê³ÉÃüÁî¡ ......

ÔÚSQL Server 2005Êý¾Ý¿âÖÐʵÏÖ×Ô¶¯±¸·Ý

µÚ1ÖÖ·½·¨£º
ÆóÒµ¹ÜÀíÆ÷
  --¹ÜÀí
  --ÓÒ¼üÊý¾Ý¿âά»¤¼Æ»®
  --н¨Î¬»¤¼Æ»®
  --<ÏÂÒ»²½>
  --Ñ¡ÔñÄãÒª±¸·ÝµÄÊý¾Ý¿â
  --<ÏÂÒ»²½>Ö±µ½"Ö¸¶¨Êý¾Ý¿â±¸·Ý¼Æ»®"ÕâÏî
  --Ö¸¶¨´æ´¢±¸·ÝÎļþµÄλÖÃ,ÕâÀï¸ù¾ÝÐèҪѡÔñ±¸·Öµ½´Å´ø»¹ÊÇ´ÅÅÌ
  --µ¥»÷µ÷¶ÈºóÃæµÄ"¸ü¸Ä"°´ ......

sql code

--½áºÏsys.indexesºÍsys.index_columns,sys.objects,sys.columns²éѯË÷ÒýËùÊôµÄ±í»òÊÓͼµÄÐÅÏ¢
select
  o.name as ±íÃû,
  i.name as Ë÷ÒýÃû,
  c.name as ÁÐÃû,
  i.type_desc as ÀàÐÍÃèÊö,
  is_primary_key as Ö÷¼üÔ¼Êø,
  is_unique_constraint as Î¨Ò»Ô¼Êø,
  is_disable ......

SQL×¢Èë½Ì³ÌÖ®¸ß¼¶Æª

¿´ÍêÈëÃÅÆªºÍ½ø½×ƪºó£¬ÉÔ¼ÓÁ·Ï°£¬ÆÆ½âÒ»°ãµÄÍøÕ¾ÊÇûÎÊÌâÁË¡£µ«Èç¹ûÅöµ½±íÃûÁÐÃû²Â²»µ½£¬»ò³ÌÐò×÷Õß¹ýÂËÁËÒ»Ð©ÌØÊâ×Ö·û£¬ÔõôÌá¸ß×¢ÈëµÄ³É¹¦ÂÊ£¿ÔõôÑùÌá¸ß²Â½âЧÂÊ£¿Çë´ó¼Ò½Ó×ÅÍùÏ¿´¸ß¼¶Æª¡£
µÚÒ»½Ú¡¢ÀûÓÃϵͳ±í×¢ÈëSQLServerÊý¾Ý¿â
SQLServerÊÇÒ»¸ö¹¦ÄÜÇ¿´óµÄÊý¾Ý¿âϵͳ£¬Óë²Ù×÷ϵͳҲÓнôÃܵÄÁªÏµ£¬Õâ¸ø¿ª·¢Õß´øÀ´ÁË ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ