Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ë÷Òýͳ¼ÆÐÅϢδ¼°Ê±¸üУ¬µ¼ÖÂÅÅÐò»ìÂÒ

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

windows 2003Ï°²×° sql server 2000µÄ·½·¨

    ÎÒ°²×°µÄÊÇsql server 2000ËĺÏÒ»°æ±¾£¬Õý³£Í¾¾¶Ö±½Ó°²×°ÊÇ×°²»Éϵģ¬Òª´òʲôSP3²¹¶¡£¬²»ÒªÀíËü£¬´ò¿ª°²×°°ü£¬Àï±ßÓиöMSDEĿ¼£¬Ö´ÐÐsetup.exe£¬°²×°ºÜ˳Àû£¬×°ÍêÖ®ºóÊÇûÓз´Ó¦µÄ£¬ÖØÆô¼ÆËã»ú£¬È»ºóÄÜ¿´µ½sql server·þÎñÒѾ­Æô¶¯£¬ÕâÑù£¬¾Í¿ÉÒÔÕý³£°²×°ÁË£¬Ö´Ðа²×°°ü¸ùĿ¼Ïµİ²×°³ÌÐò£¬°´Ìáʾһ²½ ......

DelphiʹÓÃiniÅäÖÃÎļþÁ¬½ÓMS SQLÊý¾Ý¿â

ºÜÔç×ö¹ýµÄÒ»¸ödelphiÏîÄ¿£¬°ÑÀïÃæÓõ½µÄ¼¼Êõ×ܽáһϣ¬Ö÷ÒªÊÇÕë¶ÔÏóÎÒÕâÑùµÄdelphiÐÂÊÖ£¬¼¼ÊõÉÏ×ö¸ö»ýÀÛ°É£¡
¼ÙÉèÎÒÃǵÄÊý¾Ý¿âÅäÖÃÎļþServerInfo.iniÄÚÈÝÈçÏ£º
[ServerInfo]  
ServerIP=192.168.1.5
SQLDBName=Data 
SQLUserID=sa  
SQLPwd=  
ÎÒÃǶ¨ÒåÒ»¸öÁ¬½ÓÊý¾Ý¿âµÄ¹ý ......

DateTimeÀàÐ͵ÄÊý¾ÝSQLÓï¾äת»»

ÒÔÏÂתÔØ£¬Ô­ÎÄÕª×Ôhttp://www.cnblogs.com/fubeidong/archive/2007/07/06/526247.html
Êý¾Ý¿âÖÐÓиö×ֶνÐorderTime£¬ÊÇDateTimeÀàÐ͵ÄÊý¾Ý£¬Èç¹ûÎÒÃÇÓÃÒÔÏÂSQLÓï¾ä°ÑËüÈ¡³öÀ´£º
select
orderTime
from orders
Ôò»á°Ñʱ¼ä¶¼ÏÔʾ³öÀ´£¬¶øÈç¹û¸Ä³ÉÏÂÃæµÄSQLÓï¾ä£º
select
orderTime = convert(varchar(10),orderTime, ......

SQL SERVERÖÐһЩÌرðµØ·½µÄÌرð½â·¨

SQL code
/*----------------------------------------------------------------
-- Author :feixianxxx(poofly)
-- Date :2010-04-20 20:10:41
-- Version:
-- Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)
Mar 29 2009 10:27:29
Copyright (c) 1988-2008 Microsoft Co ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ