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

Êý¾Ý¿âÃüÃû¹æ·¶£¨ÊÊÓÃ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


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......

sql group by Óë havingµÄÓ÷¨

1. GROUP BY ÊÇ·Ö×é²éѯ, Ò»°ã GROUP BY ÊǺ;ۺϺ¯ÊýÅäºÏʹÓÃ
group by ÓÐÒ»¸öÔ­Ôò,¾ÍÊÇ select ºóÃæµÄËùÓÐÁÐÖÐ,ûÓÐʹÓþۺϺ¯ÊýµÄÁÐ,±ØÐë³öÏÖÔÚ group by ºóÃæ£¨ÖØÒª£©
ÀýÈç,ÓÐÈçÏÂÊý¾Ý¿â±í£º
A    B
1    abc
1    bcd
1    asdfg
 Èç¹ûÓÐÈ ......

Sql°æ±¾³ýÈ¥html²¢½ØÈ¡Ö¸¶¨³¤¶ÈµÄ×Ö·û´®

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
Go
----½ØÈ¡×Ö·û´®£¬²¢³öÈ¥html
create FUNCTION [dbo].[CutString] (@str varchar(1000),@length int) 
RETURNS varchar(1000) AS 
BEGIN
 declare @mainstr varchar(1000)
 declare @substr varchar(1000)
 if(@str is not null or @st ......

[SQL Server]¹ØÓÚ¶Ôʱ¼ä´ÁtimestampÀí½â

Ò»Ö±¶Ôʱ¼ä´ÁµÄ¸ÅÄîÄ£ºý£¬²¢ÇÒÍøÉÏÒ²ÓкܶàÅóÓÑÒ²¶¼ÎóÈÏΪ£ºÊÇÒ»¸öʱ¼ä×ֶΣ¬Ã¿´ÎÔö¼ÓÊý¾Ýʱ£¬ÌîÈ뵱ǰµÄʱ¼äÖµ¡£µ¼ÖÂÒ²Îóµ¼Á˺ܶàÅóÓÑ¡£
 
Õâ´Î¿´Á˺ܶà×ÊÁÏ£¬¾ÀÕýÒ»ÏÂÕâ¸ö´íÎó£¬×Ô¼ºÒ²¸ãÇå³þ£ºÊý¾Ý¿âÖÐ×Ô¶¯Éú³ÉµÄΨһ¶þ½øÖÆÊý×Ö£¬Óëʱ¼äºÍÈÕÆÚÎ޹صģ¬ ͨ³£ÓÃ×÷¸ø±íÐмӰ汾´ÁµÄ»úÖÆ¡£´æ´¢´óСΪ 8 ¸ö×Ö½Ú¡£
&nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ