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

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

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


Ïà¹ØÎĵµ£º

¡¾×ª¡¿ sqlͳ¼Æ£­¹ØÓÚѧÉú³É¼¨(´ð°¸)

sqlͳ¼Æ£­¹ØÓÚѧÉú³É¼¨(´ð°¸)
http://blog.sina.com.cn/s/blog_61380b320100ej9p.html
´ð°¸£º
1.       ¼ÆËãÿ¸öÈ˵Ä×ܳɼ¨²¢ÅÅÃû
select name,sum(score) as allscore from stuscore group by name order by allscore
2. &nbs ......

sqlÓï¾äÖеÄ[]


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

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

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

¾­µäSQLÓï¾ä´óÈ«ÊÕ²Ø

ÏÂÁÐÓï¾ä²¿·ÖÊÇ
Mssql
Óï¾ä£¬²»¿ÉÒÔÔÚ
access
ÖÐʹÓá£

 
¡¡¡¡
SQL
·ÖÀࣺ
 
¡¡¡¡
DDL
—Êý¾Ý¶¨ÒåÓïÑÔ
(CREATE
£¬
ALTER
£¬
DROP
£¬
DECLARE)
¡¡¡¡
DML
—Êý¾Ý²Ù×ÝÓïÑÔ
(SELECT
£¬
DELETE
£¬
UPDATE
£¬
INSERT)
¡¡¡¡
DCL
—Êý¾Ý¿ØÖÆÓïÑÔ
(GRANT
£¬
REVOK ......

SQL SERVER 2008 R2ÐÂÌØÐÔ

      ¿ÉÀ©Õ¹ÐԸĽø¡¡¡¡½èÖúÓÚÐÂÓ²¼þÉ豸¶ÔÓÚÆóÒµ°æWindows Server 2008 R2µÄÔöÇ¿£¬SQL Server2008R2½«ÄÜÖ§³Ö¸ß´ï56¸öÂß¼­´¦ÀíÆ÷ºÍ2TBÄÚ´æ¡£ÕâЩ¹¦ÄܵÄÔöÇ¿½«Ê¹µÃÆóÒµÄÜ´¦Àí¸ü¼Ó¾Þ´óµÄ¸ºÔØÁ¿£¬²¢ÄÜÔö¼Ó¿ÉÒÔͳһµ½Ò»¸öƽ̨ÉϵķþÎñÆ÷£¬ÊµÀýºÍÊý¾Ý¿âµÄÊýÁ¿¡£
¡¡¡¡ÕûºÏ¹¤¾ß
¡¡¡¡¶ÔÓÚSQLServer2008» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ