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»Ã÷°×£¬Ð»Ð»¸÷λ£¡
Ïà¹ØÎÊ´ð£º
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÓÐÒ»¸öÊý¾Ý¿âÀïÃæµÄ±íÊǶ¯Ì¬Ôø¼ÓµÄ£¬Ã¿Öܰ´ÈÕÆÚÉú³ÉÒ»¸öбíÀ´¼Ç¼µÇ¼ÐÅÏ¢,Èçlog20090927£¨ÃüÃûÓйæÂÉ£©,¸ôÒ»ÖÜÔÙÉú³ÉÒ»¸ö
ÏÖÔÚÎÒÏëʹÓô洢¹ý³ÌÀ´²éѯËùÓеĵǼÐÅÏ¢£¬¾Í°üÀ¨ËùÓеÄÈÕÖ¾±í
¸ÃÈçºÎд²ÅºÃ
Õ ......