sqlÓï¾äÖ´Ðв»³É¹¦ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access
sql="ALTER TABLE dssfs DROP COLUMN section"
sectionÊÇsqlµÄ±£Áô¹Ø¼ü×Ö£¿
³ö´íÌáʾÊÇʲô£¿ Ó¦¸Ã²»ÊDZ£Áô×Ö¡£
Microsoft JET Database Engine ´íÎó '80040e14'
ALTER TABLE Óï¾äÖеÄÓï·¨´íÎó¡£
sql="ALTER TABLE dssfs DROP COLUMN section"
Conn.Execute(sql)
section»»³É±ðµÄ×Ö¶ÎÄÜÕýÈ·Ö´ÐÐ
¶øÇÒ²»¹âɾ³ý²»ÐÐ
Èç¹û²éѯµÄ»°ÊÇÁíÒ»¸ö´íÎó
´íÎó '80004005'
δָ¶¨µÄ´íÎó
àÅ£¬ºÃÁË£¬Ð»Ð»£¬×¼±¸½áÌù£¬Ææ¹ÖµÄÊDZðµÄ×Ö¶ÎΪʲôÐУ¬½öÕâ¸ö×ֶβ»ÐÐÄØ£¿
ÔËÐл·¾³£¿ËùÓÐSQLÓï¾ä¶¼ ²»ÐУ¿
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
Çë½Ì¸ßÊÖ£º
ÒÔÏÂÊÇÊý¾Ý¿âÖеÄÈýÌõ¼Ç¼£¬Ó¢ÎÄΪ×Ö¶ÎÃû³Æ
id planname TaskBeginTime Status
329 2010Äê03 ......