¾µäSQLÓï¾ä
1,SELECT *,CASE OrderStatus WHEN 1 THEN 'δ´¦Àí' when 2 THEN 'Ëø¶¨' when
3 THEN 'ÒѳöƱ' ELSE '¹ýÆÚ' END
from dbo.T_OrderItem
2,
SELECT *,CAST(ROUND(CAST (HostWin AS FLOAT)/(HostWin+HostDraw+HostBear),2)*100 AS varchar)+'%' AS HostWinRate,
CAST(ROUND(CAST (HostDraw AS FLOAT)/(HostWin+HostDraw+HostBear),2)*100 AS varchar)+'%'AS HostDrawRate,
CAST(ROUND(CAST (HostBear AS FLOAT)/(HostWin+HostDraw+HostBear),2)*100 AS varchar)+'%' AS HostBearRate from V_DoubleBuy
?Convert.ToDateTime(row.ItemArray[0])
Ïà¹ØÎĵµ£º
1.ÓÃÒ»ÌõSqlÓï¾ä²éѯ³öÿÃŹ¦¿Î¶¼´óÓÚ80·ÖµÄѧÉúÐÕÃû
Name
Class
Result
ÕÅÈý
ÓïÎÄ
56
ÕÅÈý
Êýѧ
88
ÀîËÄ
ÓïÎÄ
92
ÀîËÄ
Êýѧ
100
ÍõÎå
ÓïÎÄ
88
ÍõÎå
Êýѧ
99
ÍõÎå
Ó¢Óï
99
-------------------------------------------------------------------------------
´ð°¸£º
SELECT DISTINCT nam ......
×î½ü,Òò¸öÈ˵çÄÔÓ²ÅÌËð»µ,йºÈëÁË500GµÄ´óÓ²ÅÌ,°²×°ÁËwindows7,ÔÚwin7Éϰ²×°Á˶à¸öÐéÄâxp»ú,ÐéÄâ»úÓëʵ¼ÊµÄ»úÆ÷(Ö÷»ú)×é³ÉÁËÒ»¸ö¾ÖÓòÍø,ʵÏÖÔÚÐéÄâ»úÖÐͨ¹ýÔ¶³ÌÁ¬½ÓÖ÷»úµÄsql server.ÏÖ½«ÎÒµÄÊÔÑé¹ý³Ì½éÉÜÈçÏÂ,¹©ÓÐÐËȤ³¢ÊԵĴóÏÀ²Î¿¼.
1. °²×°ÐéÄâ»ú»·¾³.
ÏȰ²×°window7.0Æì½¢°æ (רҵÓëÆóÒµ°æÒ²¿ ......
´Ó¹ÙÍøÏÂÔØSQL Server 2008µÄ180ÌìÊÔÓðæÆäʵÓëÕýʽ°æÄÚÈÝÊÇ»ù±¾ÏàͬµÄ£¬Î¨Ò»µÄÇø±ð¾ÍÔÚÓÚ°²×°ÅäÖÃÎļþÖÐËù°üº¬µÄkey¡£¸÷ÖÖ°æ±¾µÄSQL ServerÔÚ½øÐе½ÕâÒ»²½Ö®Ç°¶¼ÊÇÍêȫһÑùµÄ£º
Microsoft® SQL Server® 2008 Enterprise Evaluation£º¿ª·¢ÈËÔ±ÊÔÓÃÌåÑé
Microsoft® SQL Server® 2008 Enterprise Evaluatio ......
Ó¦ÓóÌÐòͨ¹ýodbc,ado»òado.netÓësql serverÁ¬½Ó,ÎÞÂÛͨ¹ýÄÇÖÖ·½Ê½½øÐÐÁ¬½Ó,ÿһÖÖÁ¬½Ó·½Ê½,Ê×ÏÈÒªÉèÖõÄÊÇÁ¬½Ó´®¡£ÒÔϾÍ˵˵¼¸ÖÖ·½Ê½µÄÁ¬½Ó´®µÄÉèÖãº
ÏÈ˵˵odbcÁ¬½Ó,odbcÈ«³ÆÎª¿ª·ÅʽÊý¾Ý¿âÁ¬½Ó,ÊÇ΢Èí×îÔç·¢²¼µÄÊý¾Ý¿âÁ¬½Ó·½Ê½¡£Á¬½Ó´®¸ñʽÈçÏ£ºdriver={sql server};server=·þÎñÆ÷°²È«Ãû;uid=Óû§Ãû;pwd=ÃÜÂë;databa ......