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

SqlÓï¾ä³ö´í£¬ - Web ¿ª·¢ / ASP

ÔËÐк󱨴íÎóÈçÏ£º
´íÎóÀàÐÍ£º
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Óï·¨´íÎó (²Ù×÷·û¶ªÊ§) ÔÚ²éѯ±í´ïʽ 'Êýѧ + 4where ÐÕÃû='Íõ¾²'' ÖС£
/edit.asp, µÚ 13 ÐÐ

[code=VB][/code]
<html><body>
<%
if session("name")="" then
response.redirect("login.asp")
end if
qkname=request("qkname")
number=request("number")
if qkname<>"" and number<>"" then
set conn=server.CreateObject("ADODB.Connection")
conn.open("driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("student.mdb"))
set rs=Server.CreateObject("ADODB.Recordset")
sql="update info set Êýѧ = Êýѧ + " & number & "where ÐÕÃû='" & qkname & "'"
rs.open sql, conn, 2, 2
conn.close()
end if
'response.write(session("name"))

%>


<form action="edit.asp"method=post>
ÐÕÃû£º<input type="text"name="qkname"size="20">ȱ¿Î½ÚÊý£º<input type="text"name="number"size="20"><p>
<input type="submit"value="Ìá½»">
</form>
</body></html>
sql="update info set Êýѧ = Êýѧ + " &


Ïà¹ØÎÊ´ð£º

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

Á½¾äSQL²¢Ò»¾ä,ÓÐÎÊÌâ. - MS-SQL Server / »ù´¡Àà

µÚÒ»¾ä:
select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je
from ht left join gfdm on ht.gfdm=gfdm.gfdm 
 join jh on ht.htbh=jh.hth 
and ht.htbh not like'del%' and ht. ......

vs2008 Á¬½Ómysql£¿ - MS-SQL Server / »ù´¡Àà

ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐË­ÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿

ÒýÓÃ
ÇëÎÊ
......

ÇóÒ»SQLд·¨ - MS-SQL Server / »ù´¡Àà

id                           url                   rank     ......

Çë½ÌSQLÓï¾ä²éѯÎÊÌ⣿ - MS-SQL Server / »ù´¡Àà

ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä  
  Id value state dattime  
  101 32.3 0 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ