VB 6.0 SQL Êý¾Ý¿â¸üÐÂÎÊÌâ
¸÷λ´óÏÀ СµÜÔÙ´ÎÓöµ½Ò»¸öÎÊÌ⣬Ê×ÏÈ£¬ÎÒÔÚÊý¾Ý¿âÖн¨Á¢ÁËÁ½Õűí tbs_xsqf(ѧÉúÇ··Ñ)ºÍtbs_xsxx£¨Ñ§ÉúÐÅÏ¢£©£¬tbs_xsqf±í×ֶΣºID name money tbs_xsxx±í×ֶΣºID name class money ÎÒÏëʵÏֵŦÄÜÊÇÈà tbs_xsxx±íÖеÄmoneyµÈÓÚtbs_xsqf±íÖеÄmoney ÎÒÔÚдSQLÓï¾ä¿ÉÒÔʵÏÖÕâ¸ö¹¦ÄÜ¡£¶øÔÚVBÖв»ÖªµÀÔõôд´úÂ룬SQLÓï¾äÈçÏ£º
SQL code:
update tbs_xsxx set money=tbs_xsqf.money1
from tbs_xsxx inner join tbs_xsqf on tbs_xsxx.name=tbs_xsqf.name
лл¸÷λÁË£¡
лл1#£¡£¡ ¹¦ÄÜÒѾʵÏÖ£¡£¡£¡ ½áÌù×ßÈË
1Â¥ÕýÈ·
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
³õѧ£¬´óµ¨ÌáÎÊ£¬Çë¸ßÊÖ²»ÁߴͽÌ
1¡¢¹ö¶¯Ìõµã»÷Óë»æÍ¼°å£¨ÆÁÄ»,Piceure1£©µÄÒÆ¶¯ÎÊÌâÒѾ½â¾ö¡£
Picture1.Top = -VScroll1.Value + bcW '´¹Ö±Òƶ¯
Picture1.Left = -HScroll1.Value + bcW ' ......
ÎÒÒªµÃµ½Ò»¸ö×Ö·û´®È磺
sdfk|||sgts
sdfsfd|||rgreg
wrfw|||sefw
¾ÍÊÇÒªµÃµ½|||ºóÃæµÄ×Ö·û´®£¬ÓÐʲôº¯ÊýÂð£¿ÔõôÓÃÄØ£¿Ð»Ð»£¡
SQL code:
select
right(col,len(col)-charindex('|||',col)-2)
f ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......