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
Ïà¹ØÎĵµ£º
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£ ......
¹¤¾ß£º
Sybase PowerDesigner 12.5
Microsoft SQL Server 2005
µÚÒ»²½£º¸ÅÒªÉè¼Æ
´ò¿ªPowerDesignerÈí¼þ£¬Éè¼Æ“¸ÅÄîÊý¾ÝÄ£ÐÍ”(Conceptual Data Model)£º
ͼ1
Éè¼Æ±í½á¹¹£º
ͼ2
ÔÚÉè¼ÆÊôÐÔ(×Ö¶Î)µÄʱºò£¬Èý¸ö×Öĸ(M¡¢P¡¢D)·Ö±ð±íʾ£º
M£ºÊÇ·ñΪ¿Õ;(√±íʾ²»ÔÊÐíΪ¿Õ)
P£ºÊÇ·ñ뻅 ......
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ÓÅ»¯²éѯ
ÊÕ²Ø
Êý¾Ý¿âµÄ²éѯÓÅ»¯¼¼Êõ
Êý¾Ý¿âϵͳÊǹÜÀíÐÅϢϵͳµÄºËÐÄ£¬»ùÓÚÊý¾Ý¿âµÄÁª»úÊÂÎñ´¦Àí£¨OLTP£©ÒÔ¼°Áª»ú·ÖÎö´¦Àí(OLAP)ÊÇÒøÐС¢ÆóÒµ¡¢Õþ¸®µÈ²¿ÃÅ×îΪÖØÒªµÄ¼ÆËã»úÓ¦
ÓÃÖ®Ò»¡£´Ó´ó¶à ......
asc °´ÉýÐòÅÅÁÐ
desc °´½µÐòÅÅÁÐ
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý ......