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

Éú³ÉsqlÓï¾äµÄÎÊÌâ accessÊý¾Ý¿â

²Ù×÷access ±¸×¢´óÓÚ64k
str1 ×ÖÊý²»¶¨ ·´Õý´óÓÚ64k


string strDele = @"UPDATE one set nr='" + str1 + "' Where name='123'";
OleDbCommand myCommand = new OleDbCommand(strDele, myConn);
myCommand.ExecuteNonQuery();

ÕâÑù¿Ï¶¨±¨´í
-------------------------------------

str2 ×ÖÊýΪ 63k
str3 ×ÖÊýΪ 63k
(str2 str3 ....ÊÇ´Óstr1½ØÈ¡µÄ)
string strDele = @"UPDATE one set nr='" + str2 + str3+"' Where name='123'";
OleDbCommand myCommand = new OleDbCommand(strDele, myConn);
myCommand.ExecuteNonQuery();
²Ù×÷³É¹¦
--------------------------------------

ÎÊÌâÊÇ


ÎÒÔõô²ÅÄܰ´str1×ÖÊýÉú³ÉÀàËÆÏÂÃæµÄ´úÂëÄØ
string strDele = @"UPDATE one set nr='" + str2 + str3+str4+"' Where name='123'";
string strDele = @"UPDATE one set nr='" + str2 + str3+str4+str5+"' Where name='123'";




²»»á¡£¡£ÓÑÇémark

ʹÓÃOLE  ObjectÀàÐÍ
http://topic.csdn.net/u/20070712/12/902691c7-46e7-4d41-ad8d-b4834bb476ec.html

ÒýÓÃ
¡­¡­
-------------------------------------

str2 ×ÖÊýΪ 63k
str3 ×ÖÊýΪ 63k
(str2 str3 ....ÊÇ´Óstr1½ØÈ¡µÄ)
string strDele = @"UPDATE one set nr=


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

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

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

C#ºÍÊý¾Ý¿âSQL - MS-SQL Server / »ù´¡Àà

ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
  SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ