Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µ¼³öEXCELÎÊÌ⣡ - .NET¼¼Êõ / ASP.NET

C# code:

SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......

WapµÄÒ»¸ö¾ÞÍ·ÌÛµÄÎÊÌ⣡ - .NET¼¼Êõ / ASP.NET

ÎÒÓÃasp.net¿ª·¢wapÕ¾µã£¬Íê³ÉºóÈ¥http://validator.w3.org/ÕâÀïÑéÖ¤ÎÒµÄWapÒ³ÃæÊÇ·ñ±ê×¼£¬ÆäËüÎÊÌâ¶¼¸ÄºÃÁË£¬
¾ÍÊ£ÕâÒ»¸ö´íÎóÁË£¬°´×ÖÃæÒâ˼Àí½âÊÇ˵nameÊôÐÔÒÑ´æÔÚ£¬ÀàËÆÕâÑùµÄ´íÎó»¹Óв»ÄÜÓÃborder ,align,sizeµ ......

asp.net³ÌÐòÔ±ÇóÖ° - .NET¼¼Êõ / ·Ç¼¼ÊõÇø

±¾È˹¤×÷¾­ÑéÒ»ÄêÒÔÉÏ
ÊìϤasp.net
ÊìϤjavascript
ÊìϤCss
ÊìϤajax
ÊìϤsqlserver2005
ÓÐÒ»ÄêµÄÏîÄ¿¾­Ñé
¾ßÌåÏîÄ¿ºÍÆäËûµÄ¾Í²»ÔÚÕâдÁË
ÓÐÒâÕßÁªÏµ£º
QQ:359233910
ÒýÓÃ
±¾È˹¤×÷¾­ÑéÒ»ÄêÒÔÉÏ
ÊìϤasp ......

ÇóÖúasp.netͼƬÉÏ´« - .NET¼¼Êõ / ASP.NET

¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£
ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£
ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£

ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ