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

SQL Server 2008 r2 °²×°¹ý³Ì¼Ç¼

×òÍí£¬µ½Î¢Èí¹Ù·½ÏÂÁËÒ»¸ö32°æ±¾µÄTrial°æ±¾¡£ÎļþÃûΪSQLFULL_x86_ENU.exe¡£Îļþ´óСΪ1.30G×óÓÒ¡£ÒòΪֻÓÐ32λһ¸ö°æ
±¾£¬±ÈSQL Server  2008ÄǸö3GµÄҪС¶àÁË¡£ºÇºÇ¡£
http://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx 
ÏÂ
ÔØÍê³Éºó£¬ÏÈжÔØÔ­À´µÄSQL Server 2008¡¡sp2,½á¹ûÕûÕûÔËÐÐÁËÁ½¸öСʱ£¬ÒòΪSQL
Server¡¡2008µÄ°²×°»úÖÆÊÇ»ùÓÚframeworkÖØдµÄ£¬ÌصãÊǷdz£ºÄʱ¼ä(ÎÒµÄС±¾±¾ÅäÖû¹ÊÇ¿ÉÒԵġ£^_^)¡£µ«²»ÐèÒªÔ­ISO»òÒþ²ØÆðÀ´
µÄMSIÎļþ(Èç¹ûÄ㲻СÐÄÊÖ¹¤É¾³ýÕâЩ°²×°ÎļþµÄ»°£¬Ò²²»±Øµ£ÐÄ¡££© ÕâÒ²ÊÇΪʲô´ó¶àÊýʱºò£¬SQL Server
2008µÄ°²×°ÈÕÖ¾Îļþsetup.log»áÓÐ1G´óСµÄÔ­Òò¡£ÒòΪ°²×°¹¤ÐòʵÔÚÊÇÌ«ÅÓ´óÁË¡£
ÑÔ¹éÕý´«¡£Ð¶ÔØÍê³Éºó£¬ÖØÆô»úÆ÷¡£×¢
Ò⣬ÒòΪÒÔÇ°Ôø¾­°²×°¹ýSQL Server¡¡2008£¬ËùÒÔһЩ×é¼þÈç.net Framework sp1µÈ²»±ØÔÙ°²×°¡£
¿ÉÒÔ
²Î¿´£º
°²×°sql2008 enterprise (EnglishÕýʽ°æ)ͼ½â
ÏÂÃæÊÇSQL Server 2008
r2µÄ°²×°¹ý³Ì,ÆäʵÓëSQL server 2008µÄ°²×°·Ç³£ÀàËÆ£¬Ö»ÊÇÒÔÇ°µÄ½Øͼ̫Óеã¶Ô²»Æð¹ÛÖÚ£¬Ìش˵ÀǸ£¡
 
 
 
 
 
 
 
 
 
 
 
 
 
ÑûÔÂ×¢£º±¾ÎÄ°æȨÓÉÑûÔÂ
ºÍCSDN¹²Í¬ËùÓУ¬×ªÔØÇë×¢Ã÷³ö´¦¡£
ÖúÈ˵ÈÓÚ×ÔÖú!  
3w@live.cn


Ïà¹ØÎĵµ£º

SQL²Ù×÷È«¼¯

ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓᣠ  
 
SQL·ÖÀࣺ   
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)   
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)   
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£ ......

ͼÎÄÏê½âÈçºÎÓÃPowerDesignerÉè¼ÆSQL Server

¹¤¾ß£º
Sybase PowerDesigner 12.5
Microsoft SQL Server 2005
µÚÒ»²½£º¸ÅÒªÉè¼Æ
´ò¿ªPowerDesignerÈí¼þ£¬Éè¼Æ“¸ÅÄîÊý¾ÝÄ£ÐÍ”(Conceptual Data Model)£º
 
ͼ1
Éè¼Æ±í½á¹¹£º
 
ͼ2
ÔÚÉè¼ÆÊôÐÔ(×Ö¶Î)µÄʱºò£¬Èý¸ö×Öĸ(M¡¢P¡¢D)·Ö±ð±íʾ£º
M£ºÊÇ·ñΪ¿Õ;(√±íʾ²»ÔÊÐíΪ¿Õ)
P£ºÊÇ·ñ뻅 ......

sql Óï¾ä´¦Àí ÈÕÆÚ´¦Àí

DATENAME([Year],
      dbo.reservation.begintime) + N'Äê' + CAST(DATEPART([Month],
      dbo.reservation.begintime) AS varchar) + N'ÔÂ' + DATENAME([Day],
      dbo.reservation.begintime) + N'ÈÕ' + DATENAME([Hour], dbo.r ......

SQLÓÅ»¯( ÒýÓà )



 
SQLÓÅ»¯²éѯ
ÊÕ²Ø



Êý¾Ý¿âµÄ²éѯÓÅ»¯¼¼Êõ
Êý¾Ý¿âϵͳÊǹÜÀíÐÅϢϵͳµÄºËÐÄ£¬»ùÓÚÊý¾Ý¿âµÄÁª»úÊÂÎñ´¦Àí£¨OLTP£©ÒÔ¼°Áª»ú·ÖÎö´¦Àí(OLAP)ÊÇÒøÐС¢ÆóÒµ¡¢Õþ¸®µÈ²¿ÃÅ×îΪÖØÒªµÄ¼ÆËã»úÓ¦
ÓÃÖ®Ò»¡£´Ó´ó¶à ......

¾­µäSQLÓï¾ä

asc °´ÉýÐòÅÅÁÐ
desc °´½µÐòÅÅÁÐ
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ