½ñÌìÔçÉÏÎÒÔÚÎÒµÄÁªÏëÈüÑM£©430±Ê¼Ç±¾ÉÏ×°SQL Server 2005ʱ£¬¼ì²âÓ²¼þ¹ýµÍ£¬×°²»ÉÏ¡£È»ºóÎÒÔÚÍøÉϲéÁËÒ»ÏÂÍøÉÏÓÐÈËÓÃÈüÑïÐͺŵÄCPU»ú×Ó×°ÉÏÁËSQL Server 2000£¬²»ÖªÎҵĻú×ӿɲ»¿ÉÒÔ×°SQL Server 2000°¡£¿
¹À¼Æ×°²»ÉÏ
ÈüÑM£©430ÅäÖÃÊÇʲôÑù×Ó??Äã¿ÉÒÔÈ¥²éÏÂSQL 2000µÄÅäÖÃÒªÇó°¡
×°¸öExpressµÄÓ¦¸ÃûÎÊÌâ
......
¸ù¾Ý°à¼¶·Ö×飬ͳ¼ÆÆ½¾ù·ÖºÍ²»¼°¸ñµÄ¸öÊý.
ÎÒµÄÏë·¨ÊÇÕâÑùµÄ.
Select avg(testScore) as ƽ¾ù·Ö, count(testScore <600) as ²»¼°¸ñÊý , from [Person] Group by Class
µ«ÊÇcount(testScore <600)ÕâÑùдºÃÏó²»¶Ô ,˸æËßÎÒÒ»ÏÂʵÏÖÕâÑùµÄЧ¹ûsqlÓï¾ä¸ÃÔõôд,¼±,¸Ðл!!!!
Ó¦¸ÃÊÇsum²»ÊÇcount°É
sum ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ö¶«¶«,WPS?
ѧдÎÚ¹ê
UCDOS°É
ÒýÓÃ
UCDOS°É
ºÃÏóÊÇ.Íü¼ÇÁË,Ê®¶àÄêǰµÄ¶«Î÷ÁË.
......
Çó£ºsqlÓÅ»¯µÄ·½·¨£¡£¡£¡
ŬÁ¦Ñ§Ï°oacle»ù´¡ÖªÊ¶
ÕâÑù×ÓÔõô»Ø´ð?
Èç¹ûÊǹØÏµ±íµÄ»°£¬Ñ§Ï°ÓôúÊý¹ØÏµ½â¾öÎÊÌ⣬ÕâÖ»Êdzõ²½¡£
ÒÔÉÏÍêÈ«¸öÈ˼û½â£¬²»³Ðµ£ÈκÎÔðÈΡ£
LZÄãÕâÑùÎʾÍÌ«³éÏóÁË¡¡
ÒýÓÃ
Çó£ºsqlÓÅ»¯µÄ·½·¨£¡£¡£¡
優»¯Ê²Ã´樣µÄsql£¬Ïµ統µÄ體ϵÊÇÔõ樣µ ......
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime < '"+endTime+"')"
ÕâÑùдÓÐÎÊÌâÂð£¬StartTime, EndTimeÔÚÊý¾Ý¿âÖÐÊÇda ......
ÎÒÓÐÒ»Õűí Create table abc (ID int primary key, A varchar(20), B varchar(20)); Êý¾Ý¿âÖÐAºÍB×ֶβ»ÄÜÖØ¸´£¬Ò²¾ÍÊDZÈÈçÎÒ²åÈëÒ»Ìõ¼Ç¼ £ºinsert into abc(ID, A, B) values(1, abc123, abc456);
ÎÒÔÚ²åÈëµÚ¶þÌõ¼Ç¼µÄʱºò£¬¾Í²»ÄܲåÈë X>=abc123,»òÕßX <=abc456µÄÊý£¬Ò²¾ÍÊÇÖ´ÐÐÕâÑùÒ»ÌõдÈëÓï¾ä¾ÍÐèÒª±¨Ð´Èë ......