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

Êý¾Ý¿âÉè¼Æ£¨6£©_ÃüÃû¼°±àÂë¹æ·¶_SQL SERVER

Ò»¡¢×ÛÊö
ÃüÃûºÍ±àÂë¹ý³ÌÖУ¬¶¨ÒåÓÐÒâÒåµÄÃû³Æ£¬ÒÔÒ×ÓÚÀí½â¡¢·½±ãÊéдΪԭÔò¡£
£¨1£©±ÜÃâʹÓÃÖÐÎÄ£¬¾¡Á¿Ê¹ÓÃÈ«Æ´Òô»òÈ«Ó¢ÎÄ£¬ÒÔ·½±ã¹ú¼Ê»¯£»
£¨2£©±ÜÃâÆ´ÒôºÍÓ¢ÎĵÄÖÐÎ÷ºÏèµ£¬È磺CAOZUO_TIME£»
£¨3£©±ÜÃâÔÚÃüÃûÖаüÀ¨¿Õ¸ñ¼°ÌØÊâ×Ö·û£»
£¨4£©±ÜÃâʹÓñ£Áô×Ö£»
£¨5£©±ÜÃâÃû³ÆÌ«³¤£¬×¢ÒâËõдµÄʹÓã¬Ëõд¹æÔòΪµ¥´ÊÇ°4¸ö×Öĸ£¬ºÏ³É´Êȡÿ¸öµ¥´ÊÇ°Á½Î»×é³É4λËõд£¬¶ÔÓÚÔ¼¶¨Êø³ÉµÄËõд²»±Ø×ñÊØÈ¡4λµÄ¹æÔò£¬±ÈÈ磺NO´ú±íNUMBER£¬Èç¹ûÈ¡NUMB·´¶øÈÃÈ˷ѽ⡣
 
¶þ¡¢ÃüÃû¹æ·¶
2.1¡¢Êý¾Ý¿â
ǰ׺£ºÊ¹ÓÃÓëÊý¾Ý¿âÒµÎñ¶ÔÏóÏà¶ÔÓ¦µÄÓ¢Îĵ¥´Ê»òÓ¢ÎÄËõд£»
Ãû³Æ£ºÊ¹ÓÃÓëÊý¾Ý¿âÒµÎñÐÔÖÊÏà¶ÔÓ¦µÄÓ¢Îĵ¥´Ê»òÓ¢ÎÄËõд£»
¾ÙÀý£ºBHO_STATISTIC
×¢Ò⣺
£¨1£©Ãû³ÆÒ»ÂÉʹÓõ¥ÊýÐÎʽ£»
£¨2£©¶¯´ÊÒ»Âɱ£³Ö¶¯±ö½á¹¹£¬Í¨³£Ôö¡¢É¾¡¢¸Ä¡¢²é¡¢Í³¼ÆµÄ¶¯×÷£¬Ê¹ÓÃADD¡¢DEL¡¢UPD¡¢QRY¡¢STA×÷ΪËõд£¬ÒÔ½µµÍÃüÃûµÄ³¤¶È£»
 
2.2¡¢Êý¾Ý¿âÎļþ¼°Îļþ×é
£¨1£©Êý¾Ý¿âÎļþ´æ·Å·¾¶£ºD:\DATA¡¢E:\LOG£»
£¨2£©Êý¾Ý¿âÎļþ×éÃüÃû£ºÖ÷Îļþ×é PRIMARY,´ÎÎļþ×é FG_ÒµÎñÄ£¿é_Êý¾Ý·ÖÀ࣬È磺FG_CONFIG_ACCOUNT£»
£¨3£©Êý¾Ý¿âÖ÷Êý¾ÝÎļþÃüÃû£ºDBNAME_DATA.MDF£¬È磺BHO_STATISTIC_DATA.MDF£»
£¨4£©Êý¾Ý¿â´ÓÊý¾ÝÎļþÃüÃû£ºDBNAME_DATA_XX.NDF£¬XXΪÁ½Î»ÕûÊý£¬²»×ãÁ½Î»µÚ1λÓÃ0²¹Æ룬È磺BHO_STATISTIC_DATA_01.NDF£»
£¨5£©Êý¾Ý¿âÈÕÖ¾ÎļþÃüÃû£ºDBNAME_LOG_XX.LDF£¬XXΪÁ½Î»ÕûÊý£¬²»×ãÁ½Î»µÚ1λÓÃ0²¹Æë,È磺BHO_STATISTIC_LOG_01.LDF£»
 
2.3¡¢Êý¾Ý¿âÂß¼­¶ÔÏó
2.3.1¡¢¼Ü¹¹
ͨ³£Ê¹ÓÃÒµÎñÄ£¿éÃû×÷Ϊ¼Ü¹¹Ãû£¬È磺ÅäÖÃÄ£¿é£¨CONFIG£©¡£
£¨1£©·½±ãÊý¾Ý¿â¶ÔÏó·ÖÀࣻ
£¨2£©·½±ãȨÏÞ¹ÜÀí¡£
 
2.3.2¡¢±í
ǰ׺¡¢Ãû³Æ¡¢ºó׺¾ùÒÔÏ»®Ïß(_)¼ä¸ô£¬×Öĸ¾ùʹÓôóд¡£
£¨1£© ʵÌå±í
ǰ׺£ºETB£¨E±íʾENTITY£©
Ãû³Æ£º¼Ü¹¹Ãû.ETB_Ãû´Ê
¾ÙÀý£ºPUBLIC.ETB_LEAGUE
 
£¨2£©¹Øϵ±í
ǰ׺£ºRTB£¨R±íʾRELATION£©
Ãû³Æ£º¼Ü¹¹Ãû.RTB_ʵÌåÓ¢Îĵ¥´ÊËõд_ʵÌåÓ¢Îĵ¥´ÊËõд[_ʵÌåÓ¢Îĵ¥´ÊËõд…]
¾ÙÀý£ºPUBLIC.RTB_HOPA_LEAG(¼´CONFIG.RTB_HOMEPAGE_LEAGUE)
 
£¨3£©ÊÂʵ±í
ǰ׺£ºFACT
Ãû³Æ£º¼Ü¹¹Ãû.FACT_¶¯±ö½á¹¹
¾ÙÀý£ºCONFIG.FACT _ADD_USER
 
£¨4£©±¨±í
ǰ׺£ºRPT£¨REPORTµÄ¼òд£©
Ãû³Æ£º¼Ü¹¹Ãû.RPT_¶¯±ö½á¹¹
¾ÙÀý£ºCONFIG.RPT_ ADD_USER
 
£¨5£©×Ö¶Î
Ãû³Æ£º´Ê_´Ê£¬È«²¿´óд
¾ÙÀý£ºFIRST_NAME
×¢Ò⣺
a)±ÜÃâ×Ö¶ÎÃûÖаüº¬±íÃû£¬Èç


Ïà¹ØÎĵµ£º

SQLÖ®¾Å SQLµÄ°²×°Óë¹ÜÀí

SQL Server °²×°×¢ÒâÊÂÏ£¡
==============================
http://www.cnblogs.com/pvistely/archive/2008/12/31/1365702.html
1. ÐèÒª.Net Framework 3.5£¬ÈôÔÚVista»ò¸ü¸ßµÄOSÉÏÐèÒª3.5 SP1µÄÖ§³Ö£¨ÔÚSQL2008°²×°µÄÇ°»á×Ô¶¯¸üа²×°£©
2. ÐèÒªWidnows PowerShellµÄÖ§³Ö,WPSÊÇÒ»¸ö¹¦Äܷdz£Ç¿´óµÄShellÓ¦Óã¬ÃüÁîÓë ......

PowerDesignerÓëSQL ServerÏàÁ¬

PowerDesignerÓëSQL ServerÏàÁ¬
ÒÔÇ°Ìý˵¹ýPowerDesigner¿ÉÒÔºÍÊý¾Ý¿âÁ¬½Ó£¬¸ù¾ÝÔÚPowerDesigner´´½¨µÄÊý¾ÝÄ£ÐÍ´´½¨±í¡¢´¥·¢Æ÷¡¢´æ´¢¹ý³Ìµ½Êý¾Ý¿âÖС£Ò²¿ÉÒÔ½«ÒÑÓеÄÊý¾Ý¿âµ¼³öµ½PowerDesignerÖÐΪÊý¾ÝÄ£ÐÍ¡£½ñÌì×öÁËһϲâÊÔ£¬·¢ÏÖȷʵºÜ¼òµ¥£¬ÏÖÔÚ²Ù×÷²½ÖèÓë´ó¼Ò·ÖÏí£º
0¡¢×¼±¸¹¤×÷
ÏÈÔÚSQL ServerÖд´½¨Ò»Êý¾Ý¿â£¬ ......

SQLÈÕÆÚ¸ñʽ»¯Ó¦ÓôóÈ«


Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
--
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(10 ......

sql Óï¾äʹÓÃ

SQLÓï¾ä(Ôö¡¢É¾¡¢¸Ä¡¢²é)
¡¡¡¡
¡¡¡¡Ò»¡¢Ôö£ºÓÐ4ÖÖ·½·¨
¡¡¡¡
¡¡¡¡1.ʹÓÃinsert²åÈëµ¥ÐÐÊý¾Ý£º
¡¡¡¡
¡¡¡¡Óï·¨£ºinsert [into] <±íÃû> [ÁÐÃû] values <ÁÐÖµ>
¡¡¡¡
¡¡¡¡Àý£ºinsert into Strdents (ÐÕÃû,ÐÔ±ð,³öÉúÈÕÆÚ) values ('¿ªÐÄÅóÅó','ÄÐ','1980/6/15')
¡¡¡¡
¡¡¡¡×¢Ò⣺into¿ÉÒÔÊ¡ÂÔ£»ÁÐÃûÁÐÖµÓöºº ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ