Çå³ýSQLServerÊý¾Ý¿âÈÕÖ¾(SqlServer2005)
ÔÚÖ÷Êý¾Ý¿âÎļþ½øÐдóÁ¿µÄɾ³ý(ÐÂÔö£¬Ð޸ͼ»áÓÐÈÕÖ¾)£¬ÈÕÖ¾ÎļþÓÐ1.5G¡£×òÌ컹ÔÊý¾Ý¿âʱ³õʼֵҲ²Å1MB¡£±ØÐëÇå³ýµô£¬²»È»Ì«Õ¼¿Õ¼äÁË¡£ÉÏÍøÕÒÁ˸öÇå³ýÈÕÖ¾µÄ·½·¨¡£Ë³Àû½«ÈÕÖ¾Îļþlog.ldf´Ó1.5G±äΪÁË1M¡£ ÎÒÖ´ÐÐÈçÏ£º
1.Çå¿ÕÈÕÖ¾
DUMP TRANSACTION ¿âÃû WITH NO_LOG
2.½Ø¶ÏÊÂÎñÈÕÖ¾£º
BACKUP LOG Êý¾Ý¿âÃû WITH NO_LOG
3.ÊÕËõÊý¾Ý¿âÎļþ(Èç¹û²»Ñ¹Ëõ,Êý¾Ý¿âµÄÎļþ²»»á¼õС)
ÓÒ¼üÊý¾Ý¿â->ÈÎÎñ->ÊÕËõ->Êý¾Ý¿â->È·¶¨
DBCC SHRINKDATABASE(Êý¾Ý¿âÃû)
4.½«Êý¾Ý¿âÉèΪ×Ô¶¯ÊÕËõ ÓÒ¼üÊý¾Ý¿â->ÊôÐÔ->Ñ¡Ïî->×Ô¶¯->×Ô¶¯ÊÕËõÉèΪTrue
Ïà¹ØÎĵµ£º
SqlServer ±íÖе±Ö®Ç°ÓмǼµÄʱºò·¢ÏÖ±íÉè¼ÆµÄ²»ºÏÀíÒª¼Ó×ֶΣ¬
µ«ÊÇalter table Skating_Consumption add MemberCardId numeric(9)Ö»ÄܼӿÉΪ¿ÕµÄ×ֶΣ¬
½â¾ö°ì·¨£¬
µÚÒ»¡¢¼Ó¸öΪ¿ÕµÄ×Ö¶Î
µÚ¶þ¡¢¸üбíÖмǼÕâ¸ö×Ö¶ÎΪij¸öÖµ
µÚÈý¡¢ÔÙ¸ü¸Ä±í×Ö¶ÎΪ·Ç¿Õ
Óï¾ä
alter table Skating_Consumption add MemberCardId nu ......
Ë÷ÒýµÄÖØÒªÐÔ
Êý¾Ý¿âÐÔÄÜÓÅ»¯ÖÐË÷Òý¾ø¶ÔÊÇÒ»¸öÖØÁ¿¼¶µÄÒòËØ£¬¿ÉÒÔ˵£¬Ë÷ÒýʹÓò»µ±£¬ÆäËüÓÅ»¯´ëÊ©½«ºÁÎÞÒâÒå¡£
¾Û´ØË÷Òý
(Clustered Index)ºÍ·Ç¾Û´ØË÷Òý
(Non- Clustered Index)
×îͨË׵ĽâÊÍÊÇ:¾Û´ØË÷ÒýµÄ˳Ðò¾ÍÊÇÊý¾ÝµÄÎïÀí´æ´¢Ë³Ðò£¬¶ø¶Ô·Ç¾Û´ØË÷ÒýµÄË÷Òý˳ÐòÓëÊý¾ÝÎïÀíÅÅÁÐ˳ÐòÎ޹ء£¾ÙÀýÀ´Ëµ£¬Äã·µ½Ð»ª×ÖµäµÄº ......
sqlite¹Ù·½Õ¾
http://www.sqlite.org/
SQL Syntax
http://www.sqlite.org/lang.html
sqliteÖÐÎÄÕ¾
http://www.sqlite.com.cn/
http://www.sqlitechina.org/
½¨Á¢Êý¾Ý¿âµµ°¸
ÓÃsqlite3½¨Á¢Êý¾Ý¿âµÄ·½·¨ºÜ¼òµ¥£¬Ö»ÒªÔÚshellϼüÈ루ÒÔÏÂ$·ûºÅΪshellÌáʾºÅ£¬ÇëÎð¼üÈ룩£º
$ sqlite3 foo.db
Èç¹ûĿ¼ÏÂûÓÐfo ......
<Language from="SQL" To="C#">
<Type from="bigint" To="long" />
<Type from="binary" To="object" />
<Type from="bit" To="bool" />
<Type from="char" To="string" />
<Type from="datetime" To="DateTime" ......
sqlserver¸½¼ÓÊý¾Ý¿â´íÎó823µÄ½â¾ö·½°¸2008-10-13 15:06sqlserver¸½¼ÓÊý¾Ý¿â´íÎó823µÄ½â¾ö·½°¸Ò»¡¢SQL-Server¸½¼ÓÊý¾Ý¿âʱʧ°Ü¡£
1¡¢Òì³£Çé¿ö£º·þÎñÆ÷ÔÚÕý³£ÔËÐеÄÇé¿öÏÂͻȻ¶Ïµç£¬µ¼ÖÂÊý¾Ý¿âÎļþË𻵣¬¾ßÌå±íÏÖÊÇ£ºÊý¾Ý¿âÃûºóÃæÓГ£¨ÖÃÒÉ£©”×ÖÑù¡£
2¡¢Òì³£·ÖÎö£º¹ØÓÚ823´íÎóµÄ SQL-SERVER ÖеİïÖú£º
=== ......