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

sqlserver order byÅÅÐòÎÊÌâ - .NET¼¼Êõ / ASP.NET

Order by ʱ¼ä×Ö¶Î desc
 ÅŲ»ÁË˳ÐòÁË
ǰÌáÊÇÎÒÕâ¸öÊÇÒ»¸öÊÔͼ£¿
ËûÔÚÐÞ¸ÄÊÔͼÀïÃæËüÅÅÐòÁË£¡¿ÉÊǵÈÎÒ´ò¿ªÊÔͼ²é¿´µÄʱºòÊý¾Ý²¢Ã»ÓнøÐÐÅÅÐò£¡£¡ºÜÊÇÓôÃÆ£¡Ï£Íû¸÷Ϊ¸ßÊÖÖ¸µã£¡£¡
¼±¼±£¡£¡£¡£¡
ËûÔÚÐÞ¸ÄÊÔͼÀïÃæËüÅÅÐòÁË£¡¿ÉÊǵÈÎÒ´ò¿ªÊÔͼ²é¿´µÄʱºòÊý¾Ý²¢Ã»ÓнøÐÐÅÅÐò£¡
Õâ¾ä»°ÎÒ¿´²»¶®


ÒýÓÃ

ËûÔÚÐÞ¸ÄÊÔͼÀïÃæËüÅÅÐòÁË£¡¿ÉÊǵÈÎÒ´ò¿ªÊÔͼ²é¿´µÄʱºòÊý¾Ý²¢Ã»ÓнøÐÐÅÅÐò£¡
Õâ¾ä»°ÎÒ¿´²»¶®



replace ÊÔͼ with ÊÓͼ

Ö´ÐÐsqlÓï¾äºó³öÀ´µÄÊý¾Ý¼¯Ó¦¸ÃÊÇÅÅÐòµÄѽ£¬ÊÓͼ±¾ÉíÊDz»»á±äµÄ

¿àÄÕ¡£¡£  

Ôõô¾õµÃÄã˵µÄ¶¼ÊÇÕý³£ÏÖÏ󡣡£

¹û¶ÏÌù³ö´úÂë

ºÃµÄ£¡£¡ÉÔµÈ

SELECT TOP (100) PERCENT dbo.LBsiT_¿Í·þ¼Ç¼.ID, dbo.LBsiT_¿Í·þ¼Ç¼.¼Ç¼ʱ¼ä, dbo.LBsiT_¿Í·þ¼Ç¼.ÊÂÓÉ, dbo.LBsiT_¿Í·þ¼Ç¼.ÊÖд¿Í»§ÐÕÃû, 
  dbo.LBsiT_¿Í·þ¼Ç¼.¿Í»§±àÂë, dbo.LBsiT_¿Í·þ¼Ç¼.¿Í»§µç»°ºÅÂë, dbo.lbsit_¿Í»§.µØÇø, dbo.LBsiT_¿Í·þ¼Ç¼.Ïà¹Ø¶©µ¥±àºÅ, 
  dbo.LBsiT_¿Í·þ¼Ç¼.Ïà¹Ø²úÆ·±àÂë, dbo.LBsiT_¿Í·þ¼Ç¼.ÏêÇé¼Ç¼, dbo.LBsiT_¿Í·þ¼Ç¼.´¦Àí·½°¸, dbo.LBsiT_¿Í·þ¼Ç¼.¿Í·þרԱ, 
  dbo.LBsiT_¿Í·þ¼Ç¼.´¦Àí½á¹û, dbo.LBsiT_¿Í·þ¼Ç¼.ÊÛºóרԱ, dbo.LBsiT_¿Í·þ¼Ç¼.ÊÂÓÉID
from dbo.LBsiT_¿Í·þ¼Ç¼ LEFT OUTER JOIN
  dbo.lbsit_¿Í»§ ON dbo.LBsiT_¿Í·þ¼Ç¼.¿Í»§±àÂë = dbo.lbsit_¿Í»§.¿¨ºÅ
ORDER BY dbo.LBsiT_¿Í·þ¼Ç¼.¼Ç¼ʱ¼ä DESC

Õâ¸öÊ


Ïà¹ØÎÊ´ð£º

ASP.NET±í¸ñŪµÃÍ´¿àËÀÁË - .NET¼¼Êõ / ASP.NET

µ÷ÕûÁËÕâÀÄÇÀï³öÎÊÌâ¡£
ÓÐûÓÐʲôºÃµÄ·½·¨£¬Ïñµ÷Õû¶Ô»°¿òÒ»Ñù£¿£¿£¿£¿
ÕÒ¸öרÃÅ×öÒ³ÃæµÄ

ÔÚdreamweaverÀïµ÷¡£¡£¡£Ò²¿ÉÒÔÖ±½Ó¿ØÖÆHTML´úÂë

ȷʵʹ¿à ¸ÐͬÉíÊÜѽ

¹þ¹þ ¼á¾ö·¹ý¡£

ÓÃDW°É£¬VS¸ãÉè¼Æ ......

ÔõÑù½«ASP³ÌÐòת»»Îª.NET³ÌÐò ? - .NET¼¼Êõ / ASP.NET

ÔõÑù½«ASP³ÌÐòת»»Îª.NET³ÌÐò ?
ÕÒ¸öÈ«²Å·­Òë¡£

ÊÖ¶¯È¥Ð´
¸Ð¾õд¹ýaspµÄ£¬À´Ð´asp.net£¬ÉÏÊÖÓ¦¸Ã¿ìµã¡£
¸üÄÜÀí½âasp.netµÄһЩÄÚ²¿¼¼Êõ
asp.net¶¼±»·â×°ÁË

ÎÒÊÇ×ö.NetµÄ£¬¶ÔASPһֱû½Ó´¥µ½£¬ºÜİÉú¡£
¹« ......

asp.net 2.0ÖÐʹÓÃÊ÷µÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

ʹÓõÄÊÇ¿ò¼Ü×Ô´øµÄtreeview
°ó¶¨ÏÔʾ£¬Äܹ»°´ÕÕÕýÈ·µÄÐÎʽÏÔʾ³öÀ´
µ«Ò»µã»÷¾Í»á±¨´í
³ÌÐò¼¯¡°System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a¡±ÖеÄÀàÐÍ¡°System.Web.UI.WebCo ......

ASP¡£netÖÐÔõôµ÷ÓÃCom+×齨 - .NET¼¼Êõ / ASP.NET

C# code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Runtime.InteropServices;
nam ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ