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

DelphiÓëSQLµÄÎļþ´æÈ¡ÎÊÌâ

ÇëÎÊ£º
1¡¢ÈçºÎÔÚDelphiÖУ¬°ÑÖ¸¶¨Îļþ±£´æµ½SQLÖУ¬SQL¶ÔÓ¦×Ö¶ÎÓÖÓ¦¸ÃÓÃʲôÀàÐͲűȽϺÏÊÊ£¿
2¡¢¶ÔÓÚ1²Ù×÷£¬ÈçºÎ°Ñ±£´æµ½SQLÖеÄÎļþ´ò¿ª£¿
3¡¢ÒÔÉÏÎļþÖ÷ÒªÕë¶ÔOffice£¨DOC¡¢XLSµÈ£©ÎļþÀàÐÍ£¬Í¼Æ¬£¨BMP¡¢JPGµÈ£©ÀàÐÍÁ½ÖÖ£¬Èç¹û»¹Äܹ»Õë¶ÔÆäËüÎļþÀàÐÍ£¨ÈçEXEµÈ£©¸üºÃ¡£
лл£¡
ÒÔºó·Ö²»¹»ÎÒ»áÔÙ¼Ó¡£

×¢ÒâÕâ¾ä£ºTblobField(TmpAdo.FieldByName('Content')).LoadfromFile(EdtFileDir.Text);


Äã¿ÉÒÔÓÃimageÀàÐͽøÐÐÎļþµÄ´æ·Å,ÒÔÎļþÁ÷ÐÎʽ,
È»ºó¶ÁÈ¡µÄʱºò,ÔÙ°ÑÎļþÁ÷תΪÎļþ±£´æ..


ÄÇ»¹²»Èç,Ö»±£´æÕâЩÎļþ¸úͼƬµÄµØÖ·
ÕâÑù¶ÁÈ¡¸ú±£´æ¸üÓÐЧÂÊ

ÒýÓÃ
ÄÇ»¹²»Èç,Ö»±£´æÕâЩÎļþ¸úͼƬµÄµØÖ·
ÕâÑù¶ÁÈ¡¸ú±£´æ¸üÓÐЧÂÊ

̸²»ÉÏʲôЧÂʸߣ¬±£´æµØÖ·´øÀ´µÄ×î´óÎÊÌ⣬¾ÍÊÇ·þÎñÆ÷µÄµØÖ·±ä¸ü£¬ÒªÁ¬Í¬ËùÓеÄÎļþÒ»Æð°áǨ£¬²»¹ýÔÚ¾Û¶àµÄÎļþÊýÁ¿Çé¿öÏ£¬ÊÇ¿ÉÒÔ²ÉÓñ£´æµØÖ·µÄ·½·¨µÄ

¶à¼ÓÒ»¸ö×Ö¶ÎExtName±£´æÎļþÀàÐ;ÍÐÐÀ²

ÄÇÄã·þÎñ¶ËµÄÎļþ¾Í±ð»»Â·¾¶ÁË£¬

ÒýÓÃ
ÒýÓà 5 Â¥ lgxyz µÄ»Ø¸´:
ÄÇ»¹²»Èç,Ö»±£´æÕâЩÎļþ¸úͼƬµÄµØÖ·
ÕâÑù¶ÁÈ¡¸ú±£´æ¸üÓÐЧÂÊ

̸²»ÉÏʲôЧÂʸߣ¬±£´æµØÖ·´øÀ´µÄ×î´óÎÊÌ⣬¾ÍÊÇ·þÎñÆ÷µÄµØÖ·±ä¸ü£¬ÒªÁ¬Í¬ËùÓеÄÎļþÒ»Æð°áǨ£¬²»¹ýÔÚ¾Û¶àµÄÎļþÊýÁ¿Çé¿öÏ£¬ÊÇ¿ÉÒÔ²ÉÓñ£´æµØÖ·µÄ·½·¨µÄ


ÄãÊý¾Ý¶¼Òª°áǨºÎÀ´Îļþ²»ÐèÒª°áÇ¨ÄØ£¿

Êý¾Ý¿â´æµÄÖ»ÊÇÎļþÏà¶ÔµØÖ·

È»ºóÔÚ´æÎļþ·þÎñÆ÷£¨¿ÉÒÔÊÇÓëÊý¾Ý¿âͬһ·þÎñÆ÷£©×ÔÒÑÔÙдһ¸ö½ÓÊÕ/·¢ËÍÎļþµÄ·þÎñ³ÌÐò¾ÍÐÐÁË


Ïà¹ØÎÊ´ð£º

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

pl/sqlµ¼ÈëÊý¾ÝÎÊÌâ

ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç  "2009-01","8949-232"

½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

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

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

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

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

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

ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......

SQL×ֶΣ¬ºáÏòÕ¹¿ª

ÇëÎʸ÷룬ÈçºÎ½«SQlÖУ¬Ä³×Ö¶ÎÖеÄÖµºáÏòÕ¹¿ªÄØ£¬
CASE WHEN

¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿´ÄãÒªÔõôչ¿ª

ÐÕÃû  ¿ÆÄ¿      ³É¼¨
ÕÅÈý  Ó¢Óï    90
ÀîËÄ  Ó¢Óï&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ