MSSQLÔõÑùÐÞ¸ÄÊý¾Ý¿âµÄÂß¼ÎļþÃû³Æ
ÎÒÓÐÒ»Êý¾ÝÊÇ´ÓLMS_DBÊý¾Ý¿â»Ö¸´³ÉÁíÒ»Êý¾Ý¿âERP_DB£¬½á¹û·¢ÏÖERP_DBÊý¾Ý¿âµÄÂß¼ÎļþÃû³Æ»¹ÊÇLMS_DBÃû³Æ£¬ÇëÎÊÔõÑùÐÞ¸ÄMS SQLÊý¾Ý¿âµÄÂß¼ÎļþÃû³Æ?
Ö±½Ó±¸·Ý³öÀ´¸Ä¸öÃû×ÖÊÔÊÔ
ALTER DATABASE
ALTER DATABASE database
MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...)
Ïà¹ØÎÊ´ð£º
RT
ºÃÏñ¿¼MSSQLÖ¤·ÖºÃ¼¸ÖÖŶ?
×ÉѯÏ ÓÐʲôÏà¹Ø×ÊÁÏô£¿
Õâ¸öÕæ²»Çå³þ£¬°ï¶¥°É
µ±È»ÊÇMICROSOFTµÄMCSEÁË
..
°ï¶¥
°ï¶¥Ï°ɡ£¡£
MS SQL ÈÏÖ¤
2000:mcdba
2005:·ÖÈý¸öϵÁÐ ¹ ......
ÎÒÉè¼ÆµÄ
Óû§ÐÅÏ¢±í ³±íÊý¾Ý±í ÀúÊ·³±íÊý¾Ý±í
ÎÒµÄÏë·¨ÊÇ Ã¿Ô³õ ϵͳ×Ô¶¯ÔÚ ³±íÊý¾Ý±íÖÐÉú²ú ÓëÓû§¹ØÁªµÄÊý¾Ý ÓÃÓÚ³±íÔ±µÄ¼È룬µ±³±íԱȫ²¿Â¼Èëºó °ÑÊý¾ÝÈ«²¿¸´ÖƵ½ÀúÊ·±íÖРͨʱ ......
_RecordsetPtr pRs("ADODB.Recordset");
"provider=SQLOLEDB;Data Source=»úÆ÷Ãû\\SQLEXPRESS;Persist Security Info=False;User ID=sa;PWD=sa;initial catalog ......
Ò»¸öÊý¾Ý¿â±í ÀïÃæµÄ×Ö¶ÎÓÐ VIPÓû§AÀà VIPÓû§bÀà VIPÓû§cÀà VIPÓû§dÀà VIPÓû§eÀà VIPÓû§fÀà ¡£¡£¡£
ÀïÃæµÄÊý¾Ý¶¼Êǵ绰ºÅÂë ......
mssqlµÄ´æ´¢¹ý³ÌÀïÔõô»ñµÃÒ»ÌõSQLÓï¾äµÄÖ´ÐÐ״̬Êdzɹ¦»¹ÊÇʧ°Ü£¿ÎÒÏëÔÚÒ»ÕűíÖÐÔö¼Ó¼Ç¼£¬Ê×ÏÈÒª¼ì²éÊÇ·ñÒѾ´æÔÚÏàͬ¼Ç¼£¬Èç¹û´æÔھ͸üУ¬·ñÔò¾Í²åÈë¡£
ÎÒ¾ÍÏëÏÈÊÔÊÔ²åÈë²Ù×÷£¬Ê§°ÜÁ˾ÍÈ¥¸üУ¬»òÕßÏÈÈ¥¸üР......