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

ado+sql´´½¨±í

¸÷λ´ó¼ÒºÃ
VC+ado+sql´´½¨±í

ÎÒÊý¾Ý¿âÀïÓÉÒ»ÕÅTABLE±í£¬ÏÖÔÚÎÒÒªÒ»ÕÅTABLE1±í¡££¨×¢£ºÎÒËù½¨µÄTABLE1±íͨ¹ý¶Ô»°¿òÉϵÄÒ»±à¼­¿òÊäÈ룬µã»÷°´Å¥ºóÒª½¨Á¢TABLE1±í£¬²¢ÇÒTABLE1±íÖеÄËùÓÐ×Ö¶ÎÊÇ´ÓTABLE±íÖжÁ³ö£¨³ýTABLE±íÖеĵÚÒ»¸öID×ֶΣ©Ò²¾ÍÊÇ˵TABLE1ÖеÄ×ֶκÍTABLEÖеÄÒ»Ñù³ýID×Ö¶ÎÍ⣩£¬Õâ¸öÎÊÌâÔõô½â¾öѽ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿

лл
ÔõôûÓÐÈ˻شð£¬Õâ¸öÎÊÌâºÜÄÑÂ𣿣¿£¿£¿£¿£¿


SELECT CASE WHEN a.colorder = 1 THEN d.name ELSE '' END AS userynht,

//ºì×Ö±êʶµÄÊÇÄãÒª¶ÁÈ¡µÄ±í


ÄãµÄQQÔÚÏßÂð£¿


Ïà¹ØÎÊ´ð£º

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

sql ÎÊÌâ

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......

SQLÎÊÌ⣿

[code=select a.fyear,b.fname,sum(a.fendbal) as fendbal,
'1ÔÂ'=case when fperiod=1 then sum(a.fendbal) else 0 end ,
'2ÔÂ'=case when fperiod=2 then sum(a.fendbal) else 0 end ,
& ......

sqlÎÊÌâ

´ó¼ÒºÃsqlÓï¾äÖеļÈÓÖÎÊÌâÔõô´¦Àí°¡£¬±ÈÈç²éѯ¼ÈÑ¡ÔñÁËÊý¾Ý¿âÓÖÑ¡ÔñÁ˲Ù×÷ϵͳµÄѧÉúÐÕÃû
ÊÇ·Ö±ð²éѯȻºóºÏ²¢Âð£¿


End_rbody_60302787//-->
¸Ã»Ø¸´ÓÚ2009-10-10 11:14:51±»°æÖ÷ɾ³ý


¶ÔÎÒÓÐÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ