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

´ò¿ªSqlÊý¾Ý¿âÎļþ£¨À©Õ¹ÃûΪmdf£©

ºó׺ÃûΪ.mdfµÄsqlÊý¾Ý¿âÈçºÎ´ò¿ª£¿
ÓÐ.mdfºÍ.ldfÁ½¸öÎļþ£¬´ò¿ª·½°¸£º
·½·¨Ò»£ºÔÚSql serverÆóÒµ¹ÜÀíÆ÷ÖÐ   -   Êý¾Ý¿â   - ÓÒ¼ü <¸½¼ÓÊý¾Ý¿â
 ·½·¨¶þ£ºÔÚVS2005ÖÐÏȽ¨Á¢Ò»¸öÓëÄãÒª´ò¿ªµÄmdfÎļþͬÃûµÄÊý¾Ý¿â£¬¼Çס´æ´¢Î»Öã¬È»ºóÓÃÄãÒª´ò¿ªµÄmdfÎļþ½«¸Õ½¨Á¢µÄmdfÊý¾Ý¿âÎļþÌæ»»¼´¿É¡£


Ïà¹ØÎĵµ£º

sql ÐÔÄܵ÷Õû

1. Ñ¡ÓÃÊʺϵÄORACLEÓÅ»¯Æ÷
   ORACLEµÄÓÅ»¯Æ÷¹²ÓÐ3ÖÖ:
   a.  RULE (»ùÓÚ¹æÔò)   b. COST (»ùÓڳɱ¾)  c. CHOOSE (Ñ¡ÔñÐÔ)
   ÉèÖÃȱʡµÄÓÅ»¯Æ÷,¿ÉÒÔͨ¹ý¶Ôinit.oraÎļþÖÐOPTIMIZER_MODE²ÎÊýµÄ¸÷ÖÖÉùÃ÷,ÈçRULE,COST,CHOOSE,ALL_ROWS,FIRST_ROWS . Ä㵱ȻҲÔÚSQL¾ä¼ ......

¡¾×ª¡¿ sqlͳ¼Æ£­¹ØÓÚѧÉú³É¼¨

sqlͳ¼Æ£­¹ØÓÚѧÉú³É¼¨
http://blog.sina.com.cn/s/blog_61380b320100ej9k.html
 
 
sqlͳ¼Æ£­¹ØÓÚѧÉú³É¼¨
ѧÉú³É¼¨±í(stuscore)£º
ÐÕÃû£ºname
¿Î³Ì£ºsubject
·ÖÊý£ºscore
ѧºÅ£ºstuid
ÕÅÈý
Êýѧ
89
1
ÕÅÈý
ÓïÎÄ
80
1
ÕÅÈý
Ó¢Óï
70
1
ÀîËÄ
Êýѧ
90
2
ÀîËÄ
ÓïÎÄ
70
2
ÀîËÄ
Ó¢Óï
......

sqlÖÐÓÃ[]µÄÔ­Òò

¼Ó[ ]ÓÃÓÚ¶¨½çÁÐÃû»ò±íÃûµÈÐÅÏ¢£¬ÒÔÇø±ðÒ»Ð©ÌØÊâµÄ²»ºÏÃüÃû¹æÔòµÄ×Ö´®£¬»òÊÇÓëϵͳ±£Áô×ÖÓгåÍ»¡£Èç"user"ÊÇSQL Server±£ÁôµÄ¹Ø¼ü×Ö£¬ËùÒÔÓÃ"select * from user"²éѯ»áÌáʾÓï·¨´íÎó¡£¼ÓÉÏÖÐÀ¨ºÅ£¬ÒÔÉùÃ÷Æä²»ÊDZ£Áô×Ö¡£ "select * from [user]" Èç¹û±íÃû²»Êǹؼü×Ö£¬ÈçCompany£¬ÔòÓÃ"select * from Company"ÊÇûÎÊÌâµÄ£¬²»Ó ......

SQL¸½¼ÓÊý¾Ý¿âºó,Êý¾Ý¿âÊÇÖ»¶ÁµÄ

 ·½·¨Ò»  
   
  1.н¨Ò»¸öͬÃûµÄÊý¾Ý¿â  
   
  2.ÔÙÍ£µôsql   server(×¢Òâ²»Òª·ÖÀëÊý¾Ý¿â)  
   
  3.ÓÃÔ­Êý¾Ý¿âµÄÊý¾ÝÎļþ¸²¸ÇµôÕâ¸öн¨µÄÊý¾Ý¿â  
   
  ......

²»ÄÜÁ¬½ÓSQL SERVER 2000 µÄ½â¾ö·½°¸

±¾ÎÄת×Ô£ºhttp://blog.csdn.net/java2000_net/archive/2008/04/05/2252640.aspx
±¾ÎÄÊÕ¼Á˲»ÄÜÁ¬½ÓSQL Server £¬±¨ The Network Adapter could not establish the connection Òì³£µÄËùÓÐÓöµ½¹ýµÄÔ­Òò£¬²¢ÌṩÁËͼÐλ¯µÄÅŲéÏòµ¼¡£
²»¹ý¸ù¾Ý¾­Ñ飬ûÓÐÉý¼¶µ½SP4µÄ¿ÉÄÜÐÔ×î¸ß¡£¿ÉÒÔÖ±½Ó¿´µÚ6²¿·Ö¡£
³£¼ûµÄ´íÎóΪ£º The N ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ