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

textareaÖеÄÄÚÈÝͨ¹ýÌí¼Ó°´Å¥Ìí¼Óµ½SQLÊý¾Ý¿âÖÐ

ÎÒ¶¨ÒåÁËÒ»¸ö textarea:
  <tr bgcolor="#CCCCCC" align="center" valign="bottom">
            <td align="right" valign="top" class="style1"  >ÎÄÕÂÄÚÈÝ£º</td>
            <td width="83%" bgcolor="#FFFFFF" align="left">
                <textarea  cols="75" rows="6" style="width: 1000px; height: 576px"></textarea>
            </td>
            </tr>
            <tr bgcolor="#abb8d6">
            <td colspan="2" width="588" align="center" height="55">
                <asp:Button ID="Button1" runat="server" Text="Ìí¼Ó" onclick="Button1_Click" Width="55px" />
                    &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
                <asp:Button ID="Button2" runat="server" Text="È¡Ïû" onclick="Button2_Click" Width="55px" />
            </td>
            </tr>
ÏÖÔÚÏëͨ¹ý“Ìí¼Ó”°´Å¥½«textareaÖеÄÄÚÈÝÌí¼Óµ½Ö¸¶¨µÄÊý¾Ý¿âÖУ¬¸ÃÔõô°ì£¿


Ïà¹ØÎĵµ£º

SQL Server²éѯÓÅ»¯

MS SQL Server²éѯÓÅ»¯·½·¨
×÷Õߣºxmllover 2007-11-29 
²éѯËÙ¶ÈÂýµÄÔ­ÒòºÜ¶à£¬³£¼ûÈçϼ¸ÖÖ 
  1¡¢Ã»ÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ) 
  2¡¢I/OÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£ 
  3¡¢Ã»Óд´½¨¼ÆËãÁе¼Ö²éѯ²»ÓÅ»¯¡£ 
  4¡¢ÄÚ´æ ......

´¢´æ¹ý³Ì SQL ¿ìËÙÉÏÊÖ¡£

   Ò»¡¢SQL´æ´¢¹ý³ÌµÄ¸ÅÄÓŵ㼰Óï·¨
¡¡¡¡ÕûÀíÔÚѧϰ³ÌÐò¹ý³Ì֮ǰ£¬ÏÈÁ˽âÏÂʲôÊÇ´æ´¢¹ý³Ì?ΪʲôҪÓô洢¹ý³Ì£¬ËûÓÐÄÇЩÓŵã
¡¡¡¡¶¨Ò壺½«³£ÓõĻòºÜ¸´ÔӵŤ×÷£¬Ô¤ÏÈÓÃSQLÓï¾äдºÃ²¢ÓÃÒ»¸öÖ¸¶¨µÄÃû³Æ´æ´¢ÆðÀ´, ÄÇôÒÔºóÒª½ÐÊý¾Ý¿âÌṩÓëÒѶ¨ÒåºÃµÄ´æ´¢¹ý³ÌµÄ¹¦ÄÜÏàͬµÄ·þÎñʱ,Ö»Ðèµ÷ÓÃexecute,¼´¿É×Ô¶¯Íê³ ......

Rebuild indexes online with SQL Server 2005

Rebuild indexes online with SQL Server 2005
http://blogs.techrepublic.com.com/datacenter/?p=249
Online index rebuild
SQL Server 2005 introduces the ability to rebuild your indexes in an
online fashion so that other processes are able to access the table
while the rebuild is occurring. Because y ......

VC++µÄADOÁ¬½ÓSQL Server²½Öè

 1£ºSQL  ServerÊý¾Ý¿âÅäÖÃ
 
 
 
¿ªÆô·þÎñÆ÷
 
 
ÍÐÅÌÏÔʾ·þÎñÆ÷Æô¶¯
 
 
 
2:ÔÚStaAfx.h ÖÐÌí¼ÓÈçÏ´úÂë
#import "C:\\Program Files\\Common Files\\System\\ado\\msado15.dll" no_namespace      rename("EOF","adoEOF")rena ......

Tips on Optimizing SQL Server Clustered Indexes

http://www.sql-server-performance.com/tips/clustered_indexes_p1.aspx
As a rule of thumb, every table should have a clustered index. Generally, but not always, the clustered index should be on a column that monotonically increases--such as an identity column, or some other column where the value is ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ