Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 µÄ»Ø¸´:
ÄÇ»¹²»Èç,Ö»±£´æÕâЩÎļþ¸úͼƬµÄµØÖ·
ÕâÑù¶ÁÈ¡¸ú±£´æ¸üÓÐЧÂÊ

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


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

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

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


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

sql ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

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

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

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

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ