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

SQL 2005 °²×°

ÏÂÔØsql2005ÍêÒÔºó½âѹ³öÀ´£¬´ó¼Ò¿ÉÒÔ¿´µ½cs_sql_2005_chs_x86Õâ¸öĿ¼£¬½øÈëÕâ¸öĿ¼ÔËÐÐsetup.exeÎļþ£¬°²×°³ÌÐò¾Í¿ªÊ¼ÔËÐÐÁË¡£
Ê×Ïȵ¯³öÀ´µÄÊÇÈí¼þÐí¿ÉÌõ¿î
¹´ÉÏÎÒ½Ó°®Ðí¿ÉÌõ¿îºÍÌõ¼þ£¬µãÏÂÒ»²½
ÕâÀïÁгöÁËSQL2005ÔËÐл·¾³£¬Ö±½Óµã°²×°
³ÌÐò¿ªÊ¼°²×°SQL2005ÔËÐбØÐèµÄ»·¾³£¬ÅäÖÃ×é¼þ
±ØÐèµÄ×é¼þ°²×°ºÃÁË£¬µãÏÂÒ»²½¼ÌÐø°²×°
³ÌÐò¼ì²é°²×°»úÆ÷µÄÅäÖ㬵ãÏÂÒ»²½¼ÌÐø°²×°
³ÌÐò¼ì²â¸÷ÖÖ°²×°±ØÐèµÄ»·¾³£¬¶¼Í¨¹ýÁ˾ͿÉÒÔÖ±½ÓµãÏÂÒ»²½¼ÌÐø°²×°ÁË
°²×°³ÌÐòÒѾ­¼¯³ÉÁËCDKEY£¬Ö±½ÓµãÏÂÒ»²½¼ÌÐø°²×°
Ñ¡ÔñÒª°²×°µÄ×é¼þ£¬Õâ¾Í¿´Ã¿¸öÈ˵ÄÐèÒªÁË£¬µÚÒ»ÏîÊý¾Ý¿â·þÎñÆ÷Êǿ϶¨Òª°²×°µÄ£¬ÆäËü¿ÉÒÔ¿´¸÷ÈËÐèÇ󣬰ÑÒª°²×°µÄ¹´ÉÏ£¬µãÏÂÒ»²½¼ÌÐø°²×°£¬Ò²¿ÉÒÔµã¸ß¼¶½øÈëÏêϸ°²×°Ñ¡Ïî
ÕâÀï¸úÇ°ÃæÒ»²½²î²»¶à£¬Ö»ÊÇÕâЩµÄÑ¡Ïî¸üÏêϸ£¬Ñ¡ºÃÒÔºóµãÏÂÒ»²½¼ÌÐø°²×°
ÕâÀïÊÇÑ¡ÔñʵÀýÃû£¬Ò»°ã¾ÍÊÇÖ±½ÓÓÃĬÈÏ£¬ÓÐÐèÒªµÄ¿ÉÒÔ×Ô¼ºÉèÖã¬ÉèÖúõãÏÂÒ»²½
ÕâÀïÑ¡Ôñ·þÎñÆô¶¯Óõ½µÄÕË»§£¬Ò»°ãÊÇÓñ¾µØϵͳÕ˺ţ¬ÏÂÃæÊÇÑ¡Ôñ°²×°ºÃÒªÆô¶¯ÄÄЩ·þÎñ£¬°´×Ô¼ºÐèҪѡÔñ£¬Ñ¡ºÃµãÏÂÒ»²½¼ÌÐø°²×°
ÕâÀïÊÇÉèÖÃÊý¾Ý¿âµÄÉí·ÝÑé֤ģʽ£¬Ò»°ãÊÇÓûìºÏģʽ£¬ÔÙ¸øSAÉèÖÃÒ»¸öÃÜÂ룬µãÏÂÒ»²½¼ÌÐø°²×°
ÕâÀïÊÇÑ¡ÔñÊý¾Ý¿âÅÅÐò¹æÔòÉèÖã¬Ò»°ãÊÇÖ±½ÓĬÈϾÍÐÐÁË£¬µãÏÂÒ»²½
ÕâÀïÊÇÉèÖð²×°¹ý³ÌÖÐÈç¹û³öÏÖ´íÎóµÄ´¦Àí£¬Ò»°ã²»Óù´£¬Ö±½ÓÏÂÒ»²½
µ½Õâ²½³ÌÐòÊÕ¼¯¹»ÁËÐÅÏ¢£¬µã°²×°£¬ÕæÕýµÄ°²×°²Å¿ªÊ¼
³ÌÐòÔÚ¸´ÖÆÎļþ£¬ÅäÖû·¾³£¬µÈ°É
µ½ÕâÀïSQL2005°²×°¾ÍÍê³ÉÁË£¬µãÏÂÒ»²½


Ïà¹ØÎĵµ£º

c# SQLÊý¾Ý¿âÔ¶³ÌÁ¬½Ó¼°ÅäÖ÷½·¨

c# SQLÊý¾Ý¿âÔ¶³ÌÁ¬½Ó¼°ÅäÖ÷½·¨
Ò»£ºC# Á¬½ÓSQLÊý¾Ý¿â
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
Server=myServerAddress;D ......

¹ØÓÚSQLÖÐÓÃJoin in ²éѯµÄÓ÷¨


ÍâÁª½Ó:ÍâÁª½Ó¿ÉÒÔÊÇ×óÏòÍâÁª½Ó¡¢ÓÒÏòÍâÁª½Ó»òÍêÕûÍⲿÁª½Ó¡£
ÔÚ   from   ×Ó¾äÖÐÖ¸¶¨ÍâÁª½Óʱ£¬¿ÉÒÔÓÉÏÂÁм¸×é¹Ø¼ü×ÖÖеÄÒ»×éÖ¸¶¨£º   
 LEFT   JOIN   »ò   LEFT   OUTER   JOIN;    
×óÏòÍâÁª½ÓµÄ½á¹û¼¯°üÀ ......

bulletedlist ¼Ó sql server ²É¼¯ÍøÕ¾µØÖ·

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{ ......

SQL ServerºÍMySQLÖÐTopÓ÷¨µÄÇø±ð

      ½ñÌìÁ·Ï°ÔÚJSPÒ³ÃæÖÐʵÏÖ·ÖҳЧ¹û£¬ÔÚ²éѯÓï¾ä·½ÃæÇ£³¶µ½ÁËtopµÄÓ÷¨¡£¼òÒª×öÒ»ÏÂ×ܽ᣺
      ΪʵÏÖÀàËÆtopµÄ¹¦ÄÜ£¬ÎÒÃÇÔÚSQL ServerÖкÍMySQLÖÐʹÓõ½µÄSQLÓï¾äÊDz»Í¬µÄ¡£
      1¡¢ÔÚSQL ServerÖУ¬ÎÒÃÇʹÓà select top N * ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ