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

delphi ÈçºÎ¹¹Ôì¶àÌõSQLÓï¾ä£¬È»ºóÒ»´Î±£´æ

Êý¾ÝÒª´ÓÁÙʱ±íתµ½ÕýʽµÄ±íÖУ¬ÒòΪ¼ÓÒªÏÈÅÅÐò²¢¼ÓÈëÐòºÅÔÙ´æÈëÕýʽ±íÖС£
ÎÒÓõÄÓÖÊÇSQL2000¡£
ËùÒÔÏë¹¹ÔìºÃ¶àÌõÓï¾ä£¬È»ºóÒ»´Î±£´æ£¬ÇëÎÊÒªÈçºÎʵÏÖ£¿
sql server±¾À´¾ÍÖ§³Ö¶àsqlÓï¾äѽ£¬¾ÍÓÃadoquery.sql.add,Ìí¼Ó¶àÌõsql

sql.add("");Ïë¼Ó¶àÉÙÌõ¾Í¼Ó¶àÉÙÌõ

Delphi(Pascal) code:
query1.sql.text :'
select * into asdf1# from asdf order by a
insert into aaaa select * from asdf1#
'


ÕâÑù×Ó¿ÉÒÔÂð£¿

ÉÙÁ˸ö = ºÅ¡£

Èç¹ûÓï¾äºÜ³¤µÄ»°¾Í·Ö¸îһϣ¬Ô­ÔòÉÏÊÇ¿ÉÒÔµÄ


Ïà¹ØÎÊ´ð£º

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

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

delphiÈçºÎµ÷ÓÃdllÎļþÖеÄexe

Çë½Ì¸÷·¸ßÊÖ¡£ÎäÁÖǰ±²¡£ÎÒ½«B.EXE×ö³É×ÊÔ´Îļþ£¬È»ºó¼Óµ½123.dllÖС£ÓÃA.EXEÀ´µ÷ÓÃ123.dllÖеÄB.EXE
Çë¸÷λǰ±²°ïæָ½ÌÏ¡£A.exeÈçºÎÀ´µ÷ÓÃdllÖеÄexe£¿´úÂëÓÖ¸ÃÈçºÎд£¿


ÎÞÈ˻شð£¿

×ö³É×ÊÔ´Î ......

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

pl/SqlÈçºÎ²éѯ×Ö·û´®°üÀ¨%

pl/SqlÈçºÎ²éѯ×Ö·û´®°üÀ¨%, 
ÀýÈç:TABLE a
columnA
'222'
'33%44'
ÈçºÎ²éѯ±íaÖÐcolumnA×Ö¶ÎÖÐÄÄЩÐаüº¬'%'
лл
select * from a
where columna like '%/%%' escape '/'

UP

SELECT * from a ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ