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

SQL Server 2005ÐÂÔöµÄ¹¦ÄÜ

1. еIJúÆ·°æ±¾
³ýSQL Server 2005±ê×¼°æºÍÆóÒµ°æÖ®Í⣬²úÆ·ÏßÖл¹¼ÓÈëÁËSQL Server 2005¼ò»¯°æ£¨SQL Server 2005 Express£©ºÍ¹¤×÷×é°æ£¨SQL Server 2005 Workgroup£©Á½¸öа汾¡£
SQL Server 2005 Express——Æä×÷ÓÃÊÇ´úÌæ΢ÈíSQL Server×ÀÃæÒýÇ棨Microsoft SQL Server Desktop Engine£¬MSDE£©¡£SQL Server 2005 Express¿ÉÒÔÓÃÓÚ×ÔÓÉ·¢²¼£¬²¢ÓëSQL ServerʹÓÃͬÑùµÄ¹ØϵÊý¾Ý¿âºËÐÄÒýÇæ¡£²»Í¬µÄÊÇËü²¢²»ÏñMSDEÒ»ÑùʹÓòéѯ¹ÜÀíÆ÷¡£½öÓеÄÏÞÖÆÊÇÒ»¸öCPU£¬1GµÄÄÚ´æºÍÿ¸öÊý¾Ý¿â4GµÄ´æ´¢¿Õ¼ä¡£
SQL Server 2005——¹¤×÷×é°æ²»ÊÇ×ÔÓÉ·¢²¼µÄ¡£ËüµÄÉè¼Æ×ÅÑÛµãÔÚÓÚ·þÎñÆ÷ÏûÏ¢¿éЭÒ飨SMB£©ºÍ·Ö²¿ÃŽâ¾ö·½°¸¡£ÔÚÁ¿»¯ÐÔÄÜÉÏ£¬Ëü¸üÓÅÓÚSQL Server 2005 Express£¬²¢ÄÜÌṩ¹ØϵÊý¾Ý¿âµÄÖ§³Ö£¬Ö»ÊÇȱÉÙ·ÖÎö·þÎñ¡£¹¤×÷×é°æÏÞÓÃÓÚÁ½¸öCPU£¬3GÄڴ棬Êý¾Ý¿â´óС²»ÏÞ¡£
2. еÄ×Óϵͳ
ÔÚһЩеÄ×ÓϵͳµÄÍƶ¯Ï£¬SQL Server 2005ÖеÄÓ¦ÓóÌÐòÖ§³Ö·Ç³£Ç¿´ó£¬ÆäÖаüÀ¨ÕûºÏ·þÎñ¡¢ÌáÐÑ·þÎñ¡¢·þÎñ´úÀíºÍ±¨¸æ·þÎñ¡£
ÕûºÏ·þÎñ——Óë֮ǰ¸ºÔð´Ë¹¦ÄܵÄDTSÏà±È£¬Ëٶȿì600%¡£SQL ServerÕûºÏ·þÎñÊÇÓµÓÐÇ¿´óµÄ¹¤×÷Á÷¿ØÖÆÄÜÁ¦µÄÆóÒµ¼¶ETLƽ̨¡£
ÌáÐÑ·þÎñ——¿ÉÒÔÌṩ´î½¨×Ô¶¨ÒåÌáÐѳÌÐòµÄÓ¦Óÿò¼Ü¡£
·þÎñ´úÀ헗Ϊ½¨Á¢¸ß¶ÈÁ¿»¯³ÌÐòÌṩÒì²½½ø³Ì´¦Àí¹¦ÄÜ¡£
±¨¸æ·þÎñ——ÕâÊÇ×îÖµµÃÉý¼¶µÄÒ»ÏÄÜ¡£±¨¸æ·þÎñÊÇÆóÒµ¼¶µÄ±¨¸æÉú³Éƽ̨£¬¿ÉÒÔ¶ÔÉè¼Æ¡¢²¼Êð¡¢ÏúÊÛ½øÐÐÏêϸµÄ±¨¸æ¡£Ç¿´óµÄReportBuilder×é¼þ¿ÉÒÔÈÃ×îÖÕÓû§Ò²ÏíÊܵ½±¨¸æ·þÎñ¡£
3.ÕûºÏȫеÄ.NET Framework
¶ÔSQL Server 2005½øÐеÄ×î´óµÄÇ¿»¯¾ÍÊÇÕûºÏÁË.NET Framework¡£ÆôÓÃеÄ.NETÕûºÏ¹¦Äܺó£¬Äã¿ÉÒÔÇáËɵش´½¨´æ´¢¹ý³Ì¡¢º¯Êý¡¢´¥·¢Æ÷¡¢×Ô¶¨ÒåÀàÐÍ¡¢×Ô¶¨ÒåÊý¾Ý¼¯¡£Äã¿ÉÒÔÔÚÈκÎ.NETÓïÑÔÏÂʹÓÃEXEC sp_configure ‘clr enabled' , ‘1'ÃüÁîÆôÓÃCLRÖ§³Ö¡£Èç¹ûÄ㻹ÔÚʹÓùýÈ¥µÄδ¹ÜÀíµÄÀ©Õ¹´æ´¢¹ý³Ì£¬Ó¦¸ÃÁ¢¼´ÓÃSQLCLR´æ´¢¹ý³Ì´úÌæ¡£
3. еÄÊý¾ÝÀàÐÍ
SQL Server 2005ÖÐÌí¼ÓÁËÁ½ÖÖеÄÊý¾ÝÀàÐÍ£ºxmlºÍvarbinary(max)¡£
XmlÊý¾ÝÀàÐÍ——¿ÉÒÔÓÃÓÚÔÚSQL ServerÊý¾Ý¿âÖд洢ÀàÐÍ»¯»ò·ÇÀàÐÍ»¯µÄXMLÊý¾Ý£¬²¢Í¨¹ýXquery½øÐвéѯ¡£
Varbinary(max)Êý¾ÝÀàÐÍ——¿ÉÒÔÏñ·ÃÎÊÆÕͨÊý¾ÝÒ»Ñù¶ÔͼÏñµÈ¶þ½øÖÆÊý¾Ý½øÐд洢ºÍ¶ÁÈ¡¡£
4. еĵã¶ÔµãÊÂÎñÐÍÓ³Éä
ͨ¹ýSQL Server 2005ÖеÄй¦ÄÜ£¬ÎÒÃÇ¿ÉÒÔÇáËÉÕÆÎÕ΢Èí¶


Ïà¹ØÎĵµ£º

SQL ServerÑ¡ÔñÁ˷Ǿۼ¯Ë÷Òý¶ø²»ÊǾۼ¯Ë÷Òý

¾Û¼¯Ë÷Òý²»½ö°üº¬Ë÷ÒýµÄkeyÖµ£¬»¹°üº¬±íÊý¾Ý£»
·Ç¾Û¼¯Ë÷ÒýÖ»°üº¬Ë÷ÒýµÄkeyÖµ¡£
SQL ServerÔÚÓÐЩÇé¿öÏ£¬Óоۼ¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷Òý´æÔÚʱ£¬»áÑ¡Ôñ×߷Ǿۼ¯Ë÷Òý£¬¶ø²»×ß¾Û¼¯Ë÷Òý¡£
Àý×ÓÈçÏ£º
ÔÚ SQL Server µÄadventureWorksÊý¾Ý¿âÏ£¬ÔËÐÐÈçÏÂÓï¾ä£º
select DepartmentID,Name from HumanResources.Department
Departm ......

SQL ServerË÷Òýͳ¼ÆÐÅϢδ¼°Ê±¸üУ¬µ¼ÖÂÅÅÐò»ìÂÒ

½ñÌ죬Óöµ½ÁËÕâÑùµÄÒ»¸öÀý×Ó£º
SQL ServerË÷Òýͳ¼ÆÐÅϢδ¼°Ê±¸üУ¬µ¼ÖÂÅÅÐò»ìÂÒ
ÎÒÃÇÖªµÀ£¬ÔÚsql
serverÉÏ´´½¨Ë÷Òýºó£¬Í¬Ê±»á¶Ô¸ÃË÷ÒýÉϵÄÖµ½øÐÐÅÅÐò£¬µ«¶ÔÓÚÐÂÔö¼ÓµÄÖµ£¬Èç¹ûδÄܼ°Ê±¸üÐÂͳ¼ÆÐÅÏ¢£¬½«ÓпÉÄܵ¼ÖÂÅÅÐòµÄ»ìÂÒ£¬Ò²¾ÍÊÇûÓÐÅÅÐò¡£
ÕâÊDzúÉúÎÊÌâµÄÓï¾ä£º
Select * from V_L_IcStockProInEntry Where FInt ......

ͬһ±í¶à×Ö¶ÎͬʱÖظ´¼Ç¼µÄSQL²éѯ¼°´¦ÀíÊý

ͬһ±í¶à×Ö¶ÎͬʱÖظ´¼Ç¼µÄSQL²éѯ¼°´¦ÀíÊý
±ÈÈçÏÖÔÚÓÐÒ»ÈËÔ±±í £¨±íÃû£ºpeosons£©
ÈôÏ뽫ÐÕÃû¡¢Éí·ÝÖ¤ºÅ¡¢×¡Ö·ÕâÈý¸ö×Ö¶ÎÍêÈ«ÏàͬµÄ¼Ç¼²éѯ³öÀ´
select p1.* from persons p1,persons p2 where p1.idp2.id and p1.cardid = p2.cardid and p1.pname = p2.pname and p1.address ......

JAVAÁ¬½Ósql server 2005 Êý¾Ý¿âÐĵÃ

Ê×ÏȵÃÏÂÔØÇý¶¯³ÌÐòµ½Î¢ÈíÍøÕ¾ÏÂÔØMicrosoft SQL Server 2005 JDBC Driver 1.2
½âѹMicrosoft SQL Server 2005 jdbc driver1.2.exe£¬°Ñsqljdbc_1.1¸´ÖƵ½%ProgramFiles%£¨Èç¹ûϵͳÔÚCÅÌÔòΪC:\Program Files£©¡£
ÉèÖÃ Classpath
JDBC Çý¶¯³ÌÐò²¢Î´°üº¬ÔÚ Java SDK ÖС£Òò´Ë£¬Èç¹ûҪʹÓøÃÇý¶¯³ÌÐò£¬±ØÐ뽫 classpath ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ