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

sql Update語¾ä錯誤

sql Update語¾ä錯誤
´ú碼ÈçÏ£º
Dim rs As ADODB.Recordset
    Dim sql2 As String
   
    If Trim(BarCode.Text = "") Then                              '掃Ãè條碼¿ò為' ',Ìáʾ
        MsgBox "ûÓÐ掃Ãè條碼£¬ÇëÖØÐÂ掃Ã裡", vbOKOnly + vbExclamation, "¾¯¸æ"
        BarCode.SetFocus
    ElseIf Trim(Len(BarCode.Text) <> 16) Then                  '掃Ãè條碼長¶È²»ÊÇ16個×Ö·û,Ìáʾ"掃Ãè條碼長¶È錯誤£¬請ÖØÐÂ掃Ãè條碼£¡"
            MsgBox "掃Ãè條碼長¶È錯誤£¬請ÖØÐÂ掃Ãè條碼£¡", vbOKOnly + vbExclamation, "¾¯¸æ"
            BarCode.SetFocus
            BarCode.Text = ""                                  '"Barcode"Çå¿Õ
            Exit Sub
    Else
      &nbs


Ïà¹ØÎÊ´ð£º

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and  xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and  ......

sql ÎÊÌâ

PBÖпª·¢µÄ¡£

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

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......

sqlÎļþ£¨Êý¾Ýº¬ÖÐÎÄ£©DOSÃüÁî´°¿ÚÎÞ·¨µ¼ÈëÎÊÌâ

ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8

ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£

½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë

ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.

ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ