SQL Server 2008ÏÂÔØ&ÆÆ½â
´Ó¹ÙÍøÏÂÔØSQL Server 2008µÄ180ÌìÊÔÓðæÆäʵÓëÕýʽ°æÄÚÈÝÊÇ»ù±¾ÏàͬµÄ£¬Î¨Ò»µÄÇø±ð¾ÍÔÚÓÚ°²×°ÅäÖÃÎļþÖÐËù°üº¬µÄkey¡£¸÷ÖÖ°æ±¾µÄSQL ServerÔÚ½øÐе½ÕâÒ»²½Ö®Ç°¶¼ÊÇÍêȫһÑùµÄ£º
Microsoft® SQL Server® 2008 Enterprise Evaluation£º¿ª·¢ÈËÔ±ÊÔÓÃÌåÑé
Microsoft® SQL Server® 2008 Enterprise Evaluation£ºIT רҵÈËÔ±ÊÔÓÃÌåÑé
Microsoft® SQL Server® 2008 Express
Microsoft® SQL Server® 2008 Express with Tools
Èç¹ûÄãûÓÐÐòÁкţ¬ÄÇô¾ÍÖ»ÄÜÔÚÉÏÃæµÄÈýÖÖfree edition£¨Enterprise Evaluation¡¢Express¡¢Express with Advanced Service£©ÖÐÑ¡ÔñÆäÒ»¡£Èç¹ûÔÚÏÂÃæÌîÈëÐòÁкţ¬ÄÇô¾Í»á°²×°´ËÐòÁкÅËù¶ÔÓ¦µÄSQL°æ±¾£¬ÕâÒ»µãºÍWindows Server 2008ÊÇÏàËÆµÄ¡£
Ìṩ¸ø´ó¼Ò¼¸¸ökey£¬½ö¹©Ñ§Ï°£¬Çë²»ÒªÓÃ×÷ËûÓá£
Developer: PTTFM-X467G-P7RH2-3Q6CG-4DMYB
Enterprise: JD8Y6-HQG69-P9H84-XDTPG-34MBB
Microsoft.SQL.Server.2008.Developer.Edition
PTTFM-X467G-P7RH2-3Q6CG-4DMYB
Microsoft.SQL.Server.2008.Enterprise.Edition
JD8Y6-HQG69-P9H84-XDTPG-34MBB
Microsoft.SQL.Server.2008.Standard.Edition
FXHQY-JQF42-68VVV-PYVVR-RY3BB
Microsoft.SQL.Server.2008.Standard.Edition.for.Small.Business W72H7-DQQGJ-2QXP3-898V4-9QP3Y
Microsoft.SQL.Server.2008.Web.Edition
T4CTV-PVXVP-JH7GV-FB8DV-YMH3Y
Microsoft.SQL.Server.2008.Workgroup.Edition
QGRPG-DPHXX-Q69PJ-BBG4T-CMBYB
SQL Server 2008 Enterprise:
MQWT2-9MKBY-K8PXQ-6K4BW-TY4BD.
SQL Server 2008 Standard:
XP4FP-3VTDK-37TWH-TW77J-9MFM3.
Õýʽ°æºÍʹÓðæµÄÇø±ð
ÔÚ°²×°³ÌÐòDVDÖУ¬Ä¬ÈÏ»áÌṩµÄÐòÁкÅÊÇÓÉDefaultSetup.iniµÄÄÚÈÝÀ´¾ö¶¨µÄ£º
ÊÔÓðæÊÇûÓÐÕâ¸öÎļþ£¬ Õýʽ°æÕâ¸öÎļþλÓÚx86\SetupϵÄconfig.xmlÎļþÀïÏ£¬Èç¹ûÄãµÄ»úÆ÷ÊÇ64λµÄ£¬ÔòλÓÚÔÚ\x64\SetupÓÐÒ»¸öconfig.xmlÀïÃæÓÐÒ»¾ä<!-- <PIDKEY Value="BCDFGHJKMPQRTVWXY2346789B" /> -->£¬½«ÆäÖеÄ×Ö·û´®Ìæ»»¼´¿ÉÏÂÒýÓÃÆäÄÚÈÝÈçÏ£ºÒýÓÃ:
;SQLSERVER2008 Configuration File
[SQLSERVER2008]
PID="***XX-***XX-***XX-***XX-***XX"
PID="***XX-***XX-***XX-***XX-***XX"Ö»ÒªÎÒÃǽ«×Ô¼ºÓµÓеÄÐòÁкÅÌæ»»PID=ºóÃæµÄÄÇÒ»´®£¬ÔòÔÚ°²×°¹ý³ÌÖУ¬½øÐе½Ç°ÃæÌáµ½µÄÊäÈëkeyÒ»²½Ê±£¬»á×Ô¶¯ÎªÄãÌîÈëÕâÀïµÄÐòÁкš£Î¢Èí¹Ù·½µÄ
Ïà¹ØÎĵµ£º
Ô¶³ÌÁ¬½Ósql server 2000·þÎñÆ÷µÄ½â¾ö·½°¸
----ת×Ô£º·ÉºüСÎÝ
ÓÉÓ ......
Äãд¹ýÒ»ÌõsqlÓï¾äÀ´ÐÞ¸ÄÁ½¸ö±íµÄÊý¾ÝÂð£¿
UPDATE test.table1 t1,test.table2 t2 SET t1.aa='a',t1.bb='b',t2.cc='c',WHERE t1.u_id=t2.u_id AND t1.u_id='1' £»
table1µÄu_idºÍtable2µÄu_idÊÇÖ÷Íâ¼ü¹ØÏµ ......
Sql³£ÓÃÓï·¨ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK) Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE ......