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

SQLÏà¹ØÎÊÌ⣿

ÓÐÁ½ÌõSQLÓï¾ä£¨Ò»¸ö¿ªÊ¼Ò»¸ö½áÊø£©£¬ÎÒÏëÔÚ×ÀÃæÉÏÖ´ÐУ¬¹âÌý˵Ҫ×ö¸ö´°Ì廹ÊǿؼþµÄ£¬ÕâÔõô×ö£¿ÇóÀÏʦÃǰïæ£¬ÏÈлл£¡£¡£¡£¡
ʲôÒâ˼£¬Â¥Ö÷˵Çå³þЩ

...ÊÇѽ£¬ÏÈ˵Çå³þÂï

£¿

ÎÒµÄÒâ˼ÊÇ˵ÔÚ×ÀÃæÉÏ×ö¸ö°´Å¥£¬ÀïÃæÖ´ÐÐSQLÓï¾ä£¬Õâ¸ö°´Å¥Ôõô×ö£¿

isql  -U  Óû§Ãû  -P  ÃÜÂë -i c:\a.sql

ͬÑùÔÚbatÎļþÖУ¬ÊäÈëÉÏÃæÒ»ÐУ¬ÔÚa.sqlÊäÈë½Å±¾.
Èç:
use Êý¾Ý¿âÃû
go
select * from ±íÃû
go

×¢£ºÔÚcmdÏÂÊäÈ룺isql /? ¿É»ñÈ¡isqlµÄ»ù±¾Ó÷¨¡£


ѧϰ

osql»òÕßisqlÃüÁsqlseverÆóÒµ¹ÜÀíÆ÷£¬²éѯ·ÖÎöÆ÷

»¹ÊDz»Ã÷°×£¬Ð»Ð»¸÷λ£¡


Ïà¹ØÎÊ´ð£º

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

sql ÎÊÌâ

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......

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

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

ÇóÖúSQL´æ´¢¹ý³Ì

ÎÒÓÐÒ»¸öÊý¾Ý¿âÀïÃæµÄ±íÊǶ¯Ì¬Ôø¼ÓµÄ£¬Ã¿Öܰ´ÈÕÆÚÉú³ÉÒ»¸öбíÀ´¼Ç¼µÇ¼ÐÅÏ¢,Èçlog20090927£¨ÃüÃûÓйæÂÉ£©,¸ôÒ»ÖÜÔÙÉú³ÉÒ»¸ö
ÏÖÔÚÎÒÏëʹÓô洢¹ý³ÌÀ´²éѯËùÓеĵǼÐÅÏ¢£¬¾Í°üÀ¨ËùÓеÄÈÕÖ¾±í
¸ÃÈçºÎд²ÅºÃ
Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ