VFP ·R¥ÎªÌªÀ°Ï ­º­¶ VFP ·R¥ÎªÌªÀ°Ï
¥»°Q½×°Ï¬° Visual Foxpro ·R¥ÎªÌ¸gÅç¥æ¬yªº¦a¤è, ½Ð¦h¦h§Q¥Î"·j´M"ªº¥\¯à, ¥ý¬d¬Ý¬Ý¦³µL«e¨Ò¥i´`, ¦pªGÁÙ¦³¤£À´ªº¦Aµo°Ý. ³¡¥÷¥DÃD¦³ªþ¥[ÀÉ®×, ¶·¥ýµù¥U¦¨¬°ªÀ°Ï©~¥Á¤~¥i¥H¤U¸ü.
 
 ±`¨£°ÝÃD±`¨£°ÝÃD   ·j´M·j´M   ·|­û¦Cªí·|­û¦Cªí   ·|­û¸s²Õ·|­û¸s²Õ   ·|­ûµù¥U·|­ûµù¥U 
 ­Ó¤H¸ê®Æ­Ó¤H¸ê®Æ   µn¤JÀˬd±zªº¨p¤H°T®§µn¤JÀˬd±zªº¨p¤H°T®§   µn¤Jµn¤J

¦³ 7 µ§¸ê®Æ²Å¦X±z·j´Mªº±ø¥ó
VFP ·R¥ÎªÌªÀ°Ï ­º­¶
µoªí¤H ¤º®e
  ¥DÃD: ®w¦s¶q­pºâÄæ¦ì §Æ±æ®w¦s¶q·í¬°0­È®É, ´N¤£Åã¥Ü¥X¸Óµ§¾ã¦C¸ê®Æ
jslin

¦^ÂÐ: 3
Æ[¬Ý: 35228

µoªíª©­±: SQL °Q½×°Ï   µoªí©ó: ¬P´Á¥| ¤K¤ë 08, 2013 7:45 pm   ¥DÃD: ®w¦s¶q­pºâÄæ¦ì §Æ±æ®w¦s¶q·í¬°0­È®É, ´N¤£Åã¥Ü¥X¸Óµ§¾ã¦C¸ê®Æ
¦U¦ì¥ý¶i¦n

¤p§Ì¦³­ÓSQL ®w¦s¶q­pºâÄæ¦ì §Æ±æ®w¦s¶q·í¬°0­È®É, ´N¤£Åã¥Ü¥X¸Óµ§¾ã¦C¸ê®Æ

¥H¤U¬°­ì©lSQL»yªk¸òµ²ªG, ¤£ª¾¹DÀ³¸Ó¦p¦ó­×§ï .... ¤~¯à±Æ°£±¼®w¦s¶q¬°0¸ê®Æ(¦p§Ç¸¹ 35 39 41) ....?? ³Â·Ð¦U¦ì¥ý¶i­Ì ...
  ¥DÃD: SQL - ¥X²{³Ì¾aªñ 20121231¤é´Á¸ê®Æ
jslin

¦^ÂÐ: 5
Æ[¬Ý: 38640

µoªíª©­±: SQL °Q½×°Ï   µoªí©ó: ¬P´Á¤G ¤T¤ë 26, 2013 10:57 am   ¥DÃD: SQL - ¥X²{³Ì¾aªñ 20121231¤é´Á¸ê®Æ
§â¤é´Á´«ºâ¦¨¼Æ¦r,
®tÃB¨úµ´¹ï­È.


XD

¤£¦n·N«ä MAX(LA007) ¤w¸g¬O¼Æ¦r
¯à§_§ó©ú½T«üÂI°g¬z «D±`ÁÂÁ ~~~
  ¥DÃD: SQL - ¥X²{³Ì¾aªñ 20121231¤é´Á¸ê®Æ
jslin

¦^ÂÐ: 5
Æ[¬Ý: 38640

µoªíª©­±: SQL °Q½×°Ï   µoªí©ó: ¬P´Á¤G ¤T¤ë 26, 2013 9:39 am   ¥DÃD: SQL - ¥X²{³Ì¾aªñ 20121231¤é´Á¸ê®Æ
µ²ªG§Æ±æ¬O¥uÅã¥Ü¨C¤@­Ó«~¸¹¦b20130101000¤§«e©Ò²£¥Íªº³Ì«á¤@µ§¸ê®Æ(¤]´N¬O¤p©ó20130101¤é´Á¸ê®Æ)
Ãþ¦p:«~¸¹ 201002-02-12-055401 «~¦W §LªG_©Ó¬SELECT LA001 AS «~¸¹, MB002 AS «~¦W, MB003 AS ³W®æ, MB064 AS ®w¦ ...
  ¥DÃD: §PÂ_ ¹F¦¨²v¦Ê¤À ªºÄæ¦ì­È
jslin

¦^ÂÐ: 3
Æ[¬Ý: 40435

µoªíª©­±: SQL °Q½×°Ï   µoªí©ó: ¬P´Á¥| ¤E¤ë 02, 2010 12:03 pm   ¥DÃD: §PÂ_ ¹F¦¨²v¦Ê¤À ªºÄæ¦ì­È
CASE WHEN ROUND(((LC005 - LC011) / LC005 * 100),2) > 70 THEN 'YES'
ELSE 'NO' END AS

«D±`¦a·PÁ ÁA¸Ñ,,,,

¦Û¤v¦A­×¥¿¤@¤UÁYµu»yªk
SELECT LC002 AS ¦~¤ë, LC001 AS ¼t°Ó½s½X, MA002 AS ¼t°Ó¦Wº ...
  ¥DÃD: §PÂ_ ¹F¦¨²v¦Ê¤À ªºÄæ¦ì­È
jslin

¦^ÂÐ: 3
Æ[¬Ý: 40435

µoªíª©­±: SQL °Q½×°Ï   µoªí©ó: ¬P´Á¥| ¤E¤ë 02, 2010 10:38 am   ¥DÃD: §PÂ_ ¹F¦¨²v¦Ê¤À ªºÄæ¦ì­È
¦³¤@¬qSQL»yªk
SELECT LC002 AS ¦~¤ë, LC001 AS ¼t°Ó½s½X, MA002 AS ¼t°Ó¦WºÙ, LC005 AS ¤ë¥æ³fÁ`µ§¼Æ, LC011 AS ¤ë¹O´ÁÁ`µ§¼Æ ,
ROUND(((LC005 - LC011) / LC005 * 100),2) AS ¹F¦¨²v¦Ê¤À¤ñ
FROM HTWF11..PURL ...
  ¥DÃD: sql¦X¨Öªí®æ»yªk ?
jslin

¦^ÂÐ: 1
Æ[¬Ý: 10758

µoªíª©­±: SQL °Q½×°Ï   µoªí©ó: ¬P´Á¤­ ¥|¤ë 10, 2009 1:02 pm   ¥DÃD: sql¦X¨Öªí®æ»yªk ?
¤j®a¦n
§Ú¦³­Ç¬q¹L±b´Á¶¡±ø¥ó, ¤À§O¬O 20080101 ~ 20081231 ¥Nªí´Áªì ¸ò 20090101 ~ 20091231 ¥Nªí¥»´Á

select t2.acctname, t1.fathernum, sum(t3.debit) as ´Áªì­É¾l, sum(t3.credit) as ´Áªì¶U¾l, sum(t1.cur ...
  ¥DÃD: foxpro ¬O§_¥i¥H³]­p¤@®M©Ò¿× ¥Í²£±Æµ{ ¨t²Î??
jslin

¦^ÂÐ: 6
Æ[¬Ý: 7101

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤T ¤Q¤ë 22, 2008 11:33 pm   ¥DÃD: foxpro ¬O§_¥i¥H³]­p¤@®M©Ò¿× ¥Í²£±Æµ{ ¨t²Î??
¬O§_¦³ ¥Í²£±Æµ{ Sample ¥i¥H§ä¨ì¤U¸ü°Ñ¦ÒÁÂÁÂ~~~
 
²Ä1­¶(¦@1­¶)
©Ò¦³ªº®É¶¡§¡¬° ¥x¥_®É¶¡ (GMT + 8 ¤p®É)
«e©¹:  


Powered by phpBB © 2001, 2005 phpBB Group
¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@