Êý¾Ý¿âÃüÃû¹æ·¶£¨ÊÊÓÃ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
Ïà¹ØÎĵµ£º
ѧ»áÊý¾Ý¿âÊǺÜʵÓÃD~~¼Ç¼һЩ³£ÓõÄsqlÓï¾ä...ÓÐÈëÃÅÓÐÌá¸ßÓмû¶¼Ã»¼û¹ýµÄ...ºÃÈ«...ÊÕ²ØÏÂ...
Æäʵһ°ãÓõľÍÊDzéѯ,²åÈë,ɾ³ýµÈÓï¾ä¶øÒÑ....µ«Ñ§Ñ§´æ´¢¹ý³ÌÊǺÃÊÂ...ÒÔºóÊý¾Ý·½ÃæµÄ¶«Î÷¾Í²»ÓÃÔÚ³ÌÐòÀï¸ãà¶..¶øÇÒ³ÌÐòÓëÊý¾Ý¿âÖ»ÒªÒ»¸öÀ´»ØͨѶ¾Í¿ÉÒԸ㶨ËùÓÐÊý¾ÝµÄ²Ù×÷....
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
Create DAT ......
Ò»¡¢¼òµ¥ÊµÀý
1.Ê×ÏÈÀ´Ò»¸ö×î¼òµ¥µÄ´æ´¢¹ý³Ì°É
CREATE PROCEDURE dbo.testProcedure_AX
AS
select userID from USERS order by userid desc
×¢:dbo.testProcedure_AXÊÇÄã´´½¨µÄ´æ´¢¹ý³ÌÃû,¿ÉÒÔ¸ÄΪ:AXzhzµÈ,±ð¸ú¹Ø¼ü×Ö³åÍ»¾ÍÐÐÁË,ASÏÂÃæ¾ÍÊÇÒ»ÌõSQLÓï¾ä.
2.ÈçºÎÔÚASP.NETÖе÷ÓÃÕâ¸ö´æ´¢¹ý³Ì?
&n ......
1. GROUP BY ÊÇ·Ö×é²éѯ, Ò»°ã GROUP BY ÊǺ;ۺϺ¯ÊýÅäºÏʹÓÃ
group by ÓÐÒ»¸öÔÔò,¾ÍÊÇ select ºóÃæµÄËùÓÐÁÐÖÐ,ûÓÐʹÓþۺϺ¯ÊýµÄÁÐ,±ØÐë³öÏÖÔÚ group by ºóÃ棨ÖØÒª£©
ÀýÈç,ÓÐÈçÏÂÊý¾Ý¿â±í£º
A B
1 abc
1 bcd
1 asdfg
Èç¹ûÓÐÈ ......
Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚ³ÌÐòÔ±µÄˮƽ¼°¾ÑéÒ²²Î²î²»Æ룬Ï൱´óÒ»²¿·Ö³ÌÐòÔ±ÔÚ±àд´úÂëµÄʱºò£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´úÂ룬¸ù
¾Ý³ÌÐò·µ»ØµÄ½á¹û£¬»ñµÃijЩËûÏëµÃÖªµÄÊý¾Ý£¬Õâ¾ÍÊÇËùνµÄSQL ......
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
ÀýÈ磺ÏòÈÕÆÚ¼ÓÉÏ2Ìì
select dateadd(day,2,'2004-10-15') --·µ»Ø£º2004-10-17 00:00:00.000
3. datediff ·µ»Ø¿çÁ½¸öÖ¸¶¨ÈÕÆÚµÄÈÕÆÚºÍʱ¼ä ......