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»Ã÷°×£¬Ð»Ð»¸÷λ£¡
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
PBÖпª·¢µÄ¡£
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
ÎÒÓÐÒ»¸öÊý¾Ý¿âÀïÃæµÄ±íÊǶ¯Ì¬Ôø¼ÓµÄ£¬Ã¿Öܰ´ÈÕÆÚÉú³ÉÒ»¸öбíÀ´¼Ç¼µÇ¼ÐÅÏ¢,Èçlog20090927£¨ÃüÃûÓйæÂÉ£©,¸ôÒ»ÖÜÔÙÉú³ÉÒ»¸ö
ÏÖÔÚÎÒÏëʹÓô洢¹ý³ÌÀ´²éѯËùÓеĵǼÐÅÏ¢£¬¾Í°üÀ¨ËùÓеÄÈÕÖ¾±í
¸ÃÈçºÎд²ÅºÃ
Õ ......
ÇóA != 1 and B != 2 ÒÔÍâµÄ¼Ç¼
a!=1 and b!=2 ÒÔÍ⣿
ÄÇÆñ²»ÊÇa=1»òÕßb=2µÄÕâÖÖÇé¿öô
select * from table where a = 1 or b = 2
Èç¹ûÊÇA != 1 and B != 2µÄ»°
select * from table where a ......