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

SQL Server 2005ÖÐÓ¦¹Ø×¢µÄ30¸ö֪ʶµã

<!--[if !supportLists]-->Ò»¡¢<!--[endif]-->SQL Server 2005Êý¾Ý¿â¹ÜÀíµÄ10¸ö×îÖØÒªÌصã
<!--[if !supportLists]-->1.         <!--[endif]-->Êý¾Ý¿â¾µÏñ
ͨ¹ýÐÂÊý¾Ý¿â¾µÏñ·½·¨£¬½«¼Ç¼µµ°¸´«ËÍÐÔÄܽøÐÐÑÓÉì¡£Äú½«¿ÉÒÔʹÓÃÊý¾Ý¿â¾µÏñ£¬Í¨¹ý½«×Ô¶¯Ê§Ð§×ªÒƽ¨Á¢µ½Ò»¸ö´ýÓ÷þÎñÆ÷ÉÏ£¬ÔöÇ¿ÄúSQL·þÎñÆ÷ϵͳµÄ¿ÉÓÃÐÔ¡£
<!--[if !supportLists]-->2.         <!--[endif]-->ÔÚÏ߻ָ´
   Ê¹ÓÃSQL2005°æ·þÎñÆ÷£¬Êý¾Ý¿â¹ÜÀíÈËÔ±½«¿ÉÒÔÔÚSQL·þÎñÆ÷ÔËÐеÄÇé¿öÏ£¬Ö´Ðлָ´²Ù×÷¡£ÔÚÏ߻ָ´¸Ä½øÁËSQL·þÎñÆ÷µÄ¿ÉÓÃÐÔ£¬ÒòΪֻÓÐÕýÔÚ±»»Ö¸´µÄÊý¾ÝÊÇÎÞ·¨Ê¹Óõģ¬¶øÊý¾Ý¿âµÄÆäËû²¿·ÖÒÀÈ»ÔÚÏß¡¢¿É¹©Ê¹Óá£
<!--[if !supportLists]-->3.         <!--[endif]-->ÔÚÏß¼ìË÷²Ù×÷
    ÔÚÏß¼ìË÷Ñ¡Ïî¿ÉÒÔÔÚÖ¸ÊýÊý¾Ý¶¨ÒåÓïÑÔ£¨DDL£©Ö´ÐÐÆڼ䣬ÔÊÐí¶Ô»ùµ×±í¸ñ¡¢»ò¼¯´ØË÷ÒýÊý¾ÝºÍÈκÎÓйصļìË÷£¬½øÐÐͬ²½ÐÞÕý¡£ÀýÈ磬µ±Ò»¸ö¼¯´ØË÷ÒýÕýÔÚÖؽ¨µÄʱºò£¬Äú¿ÉÒÔ¶Ô»ùµ×Êý¾Ý¼ÌÐø½øÐиüС¢²¢ÇÒ¶ÔÊý¾Ý½øÐвéѯ¡£
<!--[if !supportLists]-->4.         <!--[endif]-->¿ìËÙ»Ö¸´
    Ðµġ¢Ëٶȸü¿ìµÄ»Ö¸´Ñ¡Ïî¿ÉÒԸĽøSQL·þÎñÆ÷Êý¾Ý¿âµÄ¿ÉÓÃÐÔ¡£¹ÜÀíÈËÔ±½«Äܹ»ÔÚÊÂÎñÈÕÖ¾ÏòÇ°¹ö¶¯Ö®ºó£¬ÖØÐÂÁ¬½Óµ½ÕýÔÚ»Ö¸´µÄÊý¾Ý¿â¡£
<!--[if !supportLists]-->5.         <!--[endif]-->°²È«ÐÔÄܵÄÌá¸ß
    SQL Server 2005°üÀ¨ÁËһЩÔÚ°²È«ÐÔÄÜÉϵĸĽø£¬ÀýÈçÊý¾Ý¿â¼ÓÃÜ¡¢ÉèÖð²È«Ä¬ÈÏÖµ¡¢ÔöÇ¿ÃÜÂëÕþ²ß¡¢çÇÃܵÄÐí¿É¿ØÖÆ¡¢ÒÔ¼°Ò»¸öÔöÇ¿Ð͵ݲȫģʽ¡£
<!--[if !supportLists]-->6.         <!--[endif]-->еÄSQL Server Management Studio
    SQL Server 2005ÒýÈëÁËSQL Server Management Studio£¬ÕâÊÇÒ»¸öÐÂÐ͵ÄͳһµÄ¹ÜÀí¹¤¾ß×é¡£Õâ¸ö¹¤¾ß×齫°üÀ¨Ò»Ð©ÐµĹ¦ÄÜ£¬ÒÔ¿ª·¢¡¢ÅäÖÃSQL ServerÊý¾Ý¿â£¬·¢ÏÖ²¢ÐÞÀíÆäÖеĹÊÕÏ£¬Í¬Ê±Õâ¸ö¹¤¾ß×黹¶Ô´ÓÇ°µÄ¹¦ÄܽøÐÐÁËһЩ¸Ä½ø¡£
<!--[if !supportLists]-->7.         <


Ïà¹ØÎĵµ£º

Ö´ÐÐSQLÎÄ£¬Éú³ÉEXCEL

''' <summary>
''' SQLÎÄ執ÐÐ結¹û¤ÎEXCEL³öÁ¦
''' </summary>
''' <param name="connString">OLEDB½Ó続ÎÄ×ÖÁÐ</param>
''' <param name="sqlString">SQLÎÄ</param>
''' <param name="savePath">³öÁ¦¥Õ¥¡¥¤¥ë¥Ñ¥¹</param> ......

sqlÓï¾ä»ù´¡

--sql structured query language
--DML--Data Manipulation Language--Êý¾Ý²Ù×÷ÓïÑÔ
query information (SELECT),
add new rows (INSERT),
modify existing rows (UPDATE),
delete existing rows (DELETE),
perform a conditional update or insert operation (MERGE),
see an execution plan of SQL (EXPLA ......

SQL 2K Êý¾ÝÀàÐÍ £¨×ª£©

£¨×ªÔØ£©SQL 2K Êý¾ÝÀàÐÍ 
(1)char¡¢varchar¡¢textºÍnchar¡¢nvarchar¡¢ntext
charºÍvarcharµÄ³¤¶È¶¼ÔÚ1µ½8000Ö®¼ä£¬ËüÃǵÄÇø±ðÔÚÓÚcharÊǶ¨³¤×Ö·ûÊý¾Ý£¬¶øvarcharÊDZ䳤×Ö·ûÊý¾Ý¡£Ëùν¶¨³¤¾ÍÊdz¤¶È¹Ì¶¨µÄ£¬µ±ÊäÈëµÄÊý¾Ý³¤¶ÈûÓдﵽָ¶¨µÄ³¤¶Èʱ½«×Ô¶¯ÒÔÓ¢ÎÄ¿Õ¸ñÔÚÆäºóÃæÌî³ä£¬Ê¹³¤¶È´ïµ½ÏàÓ¦µÄ³¤¶È£»¶ø±ä³¤×Ö·ûÊý¾Ý ......

sql½âÎö


SqlHelper ÀàʵÏÖÏêϸÐÅÏ¢
SqlHelper ÀàÓÃÓÚͨ¹ýÒ»×龲̬·½·¨À´·â×°Êý¾Ý·ÃÎʹ¦ÄÜ¡£¸ÃÀ಻Äܱ»¼Ì³Ð»òʵÀý»¯£¬Òò´Ë½«ÆäÉùÃ÷Ϊ°üº¬×¨Óù¹Ô캯ÊýµÄ²»¿É¼Ì³ÐÀà¡£
ÔÚ SqlHelper ÀàÖÐʵÏÖµÄÿÖÖ·½·¨¶¼ÌṩÁËÒ»×éÒ»ÖµÄÖØÔØ¡£ÕâÌṩÁËÒ»ÖֺܺõÄʹÓà SqlHelper ÀàÀ´Ö´ÐÐÃüÁîµÄģʽ£¬Í¬Ê±Îª¿ª·¢ÈËԱѡÔñ·ÃÎÊÊý¾ÝµÄ·½Ê½ÌṩÁ˱ØÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ