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

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#£¡£¡ ¹¦ÄÜÒѾ­ÊµÏÖ£¡£¡£¡ ½áÌù×ßÈË

ÒýÓÃ
Dim cn As New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\tyq.mdb;Persist Security Info=False;"
sql= "update tbs_xsxx set money=tbs_xsqf.money1 " _
  & "from tbs_xsxx inner join tbs_xsqf on tbs_xsxx.name=tbs_xsqf.name "
cn.Execute sql




1Â¥ÕýÈ·


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

VB µÄ PictureBOX ¿Ø¼þ»æÍ¼ÎÊÌâ - VB / ¿Ø¼þ

³õѧ£¬´óµ¨ÌáÎÊ£¬Çë¸ßÊÖ²»ÁߴͽÌ
1¡¢¹ö¶¯Ìõµã»÷Óë»æÍ¼°å£¨ÆÁÄ»,Piceure1£©µÄÒÆ¶¯ÎÊÌâÒѾ­½â¾ö¡£
  Picture1.Top = -VScroll1.Value + bcW '´¹Ö±Òƶ¯
  Picture1.Left = -HScroll1.Value + bcW ' ......

sql ½ØÈ¡×Ö·û´®

ÎÒÒªµÃµ½Ò»¸ö×Ö·û´®È磺
sdfk|||sgts
sdfsfd|||rgreg
wrfw|||sefw
¾ÍÊÇÒªµÃµ½|||ºóÃæµÄ×Ö·û´®£¬ÓÐʲôº¯ÊýÂð£¿ÔõôÓÃÄØ£¿Ð»Ð»£¡
SQL code:
select
right(col,len(col)-charindex('|||',col)-2)
f ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ