Êý¾Ý¿âÃüÃû¹æ·¶£¨ÊÊÓÃSQL Server£©
Éè¼ÆÔÔò
·ûºÅÈý´ó·¶Ê½£¨Ã¿Ò»Áбí´ïÒ»¸öÒâ˼£¬Ã¿Ò»Ðдú±íÒ»¸öʵÀý/ÿһÐÐÓÐΨһ¼ü/±íÄÚûÓÐÆäËü±íµÄ·ÇÖ÷¼üÐÅÏ¢£©
ÿ¸ö±íÓ¦¸ÃÓеÄ3¸öÓÐÓÃ×ֶΣ¨¼Ç¼´´½¨»ò¸üÐÂʱ¼ä/¼Ç¼´´½¨Õß/¼Ç¼°æ±¾£©
±ÜÃâ±£Áô×Ö
±íÓ¦±ÜÃâ¿ÉΪ¿ÕµÄÁÐ
ÃüÃû¹æ·¶
±í
±íÃûÈçOrder/UserAccout
·ûºÏÒÔϹ淶£º
1. ͳһ²ÉÓõ¥ÊýÐÎʽ£¬·´¶ÔOrders
2. Ê××Öĸ´óд£¬¶à¸öµ¥´ÊµÄ»°£¬µ¥´ÊÊ××Öĸ´óд£¬·´¶Ôorder/Useraccout/ORDER
3. ±ÜÃâÖÐÎÄÆ´Òô£¬·´¶ÔAgentBaoCi
4. ±ÜÃâÏ»®ÏßÁ¬½Ó£¬·´¶ÔUser_Accout£¨Ï»®ÏßÊÊÓÃOracleÊý¾Ý¿â£©
5. ±ÜÃâÃû³Æ¹ý³¤£¬·´¶ÔWebsiteInfomationModifyRecord
6. ¶à¶Ô¶à¹ØÏµ±í£¬ÒÔMapping½á⣬ÈçUserRoleMapping
7. ±ÜÃâ±£Áô×Ö
×Ö¶Î
×Ö¶ÎÃûÈçuserID/userName/userType
·ûºÏÒÔϹ淶£º
1. Ê׸ö×ÖĸСд£¬¶à¸öµ¥´ÊµÄ»°£¬µ¥´ÊÊ××Öĸ´óд£¬·´¶ÔUserID/Userid
2. ±ØÐëÓÐÒ»Ö÷¼ü£¬Ö÷¼ü²»Ö±½ÓÓÃID£¬¶øÊDZíÃû+ID£¬ÈçuserID/orderID
3. ³£ÓõÄ×Ö¶Îname£¬²»Ö±½ÓÓÃname£¬¶øÊDZíÃû+Name£¬ÈçuserName/orderName
4. ³£ÓõÄ×Ö¶Îdesc£¬²»Ö±½ÓÓÃdesc£¬¶øÊDZíÃû+Desc£¬ÈçuserDesc/orderDesc
5. ´óд×Öĸǰ±ØÐë°üº¬ÖÁÉÙÁ½¸öСдµÄ×Öĸ£¬·´¶ÔuID/oID
6. ±ÜÃâÖÐÎÄÆ´Òô
7. ±ÜÃâÏ»®ÏßÁ¬½Ó
8. ±ÜÃâÃû³Æ¹ý³¤
9. ±ÜÃâ±£Áô×Ö
¶ÔÏó
1. ´æ´¢¹ý³ÌÒÔSP_Ϊǰ׺
2. ´¥·¢Æ÷ÒÔTR_Ϊǰ׺
3. º¯ÊýÒÔFN_Ϊǰ׺
4. Ö÷¼üÒÔPK_Ϊǰ׺
5. Ë÷ÒýÒÔIX_Ϊǰ׺
6. ǰ׺ºóµÄÊ××Öĸ´óд£¬¶à¸öµ¥´ÊµÄ»°£¬µ¥´ÊÊ××Öĸ´óд£¬ÈçSP_CountFee
7. ËùÓеĹؼü×ÖµÄËùÓÐ×Öĸ±ØÐë´óд£¬ÈçSELECT userID,username from User
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE data ......
"SQL Server °²×°³ÌÐòÎÞ·¨»ñÈ¡ ASPNET ÕÊ»§µÄϵͳÕÊ»§ÐÅÏ¢"
½â¾ö°ì·¨£º
ÓÃaspnet_regiisʵÓù¤¾ßÐ¶ÔØºÍÖØÐ°²×°Ò»Ï¾ͿÉÒÔÁË¡£
¾ßÌåµÄ²Ù×÷£º
1¡¢½øÈëCMD£º
C:\windows\microsoft.net\framework\v2.0.50727Îļþ¼ÐÏ£¬ÔËÐÐaspnet_regiis -uÐ¶ÔØ
È»ºóÔËÐÐaspnet_regiis -i ÖØÐ°²×°£¬ÉÏÊöÎÊÌâ¼´¿É½â¾ö¡£
2¡¢C:\WINDOWS\ ......
ÈÕÖ¾ÎļþÂú¶øÔì³ÉSQLÊý¾Ý¿âÎÞ·¨Ð´ÈëÎļþʱ£¬¿ÉÓÃÁ½ÖÖ·½·¨£º
¡¡¡¡Ò»ÖÖ·½·¨£ºÇå¿ÕÈÕÖ¾¡£
¡¡¡¡1£®´ò¿ª²éѯ·ÖÎöÆ÷£¬ÊäÈëÃüÁî
¡¡¡¡DUMP TRANSACTION Êý¾Ý¿âÃû WITH NO_LOG
¡¡¡¡2.ÔÙ´ò¿ªÆóÒµ¹ÜÀíÆ÷--ÓÒ¼üÄãҪѹËõµÄÊý¾Ý¿â--ËùÓÐÈÎÎñ--ÊÕËõÊý¾Ý¿â--ÊÕËõÎļþ--Ñ¡ÔñÈÕÖ¾Îļþ--ÔÚÊÕËõ·½Ê½ÀïÑ¡ÔñÊÕËõÖÁXXM,ÕâÀï»á¸ø³öÒ»¸öÔÊÐíÊÕËõµ ......
DATEDIFF
·µ»Ø¿çÁ½¸öÖ¸¶¨ÈÕÆÚµÄÈÕÆÚºÍʱ¼ä±ß½çÊý¡£
Ò»¡¢ Óï·¨
DATEDIFF ( datepart , startdate , enddate )
¶þ¡¢²ÎÊý
datepar ......