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

SQL*PLUSÃüÁî sql±à³ÌÊÖ²á

 Ò»¡¢SQL PLUS
1 ÒýÑÔ
SQLÃüÁî
ÒÔÏÂ17¸öÊÇ×÷ΪÓï¾ä¿ªÍ·µÄ¹Ø¼ü×Ö£º
alter  drop  revoke
audit  grant  rollback*
commit*  insert  select
comment  lock  update
create  noaudit  validate
delete  rename
ÕâЩÃüÁî±ØÐëÒÔ“;”½áβ
´ø*ÃüÁî¾äβ²»±Ø¼Ó·ÖºÅ£¬²¢ÇÒ²»´æÈëSQL»º´æÇø¡£
SQLÖÐûÓеÄSQL*PLUSÃüÁî
ÕâЩÃüÁî²»´æÈëSQL»º´æÇø
@  define  pause
#  del  quit
$  describe  remark
/  disconnect  run
accept  document  save
append  edit  set
break  exit  show
btitle  get  spool
change  help  sqlplus
clear  host  start
column  input  timing
compute  list  ttitle
connect  newpage  undefine
copy
-------
2 Êý¾Ý¿â²éѯ
Êý¾Ý×Öµä
TAB Óû§´´½¨µÄËùÓлù±í¡¢ÊÓͼºÍͬÒå´ÊÇåµ¥
DTAB ¹¹³ÉÊý¾Ý×ÖµäµÄËùÓбí
COL Óû§´´½¨µÄ»ù±íµÄËùÓÐÁж¨ÒåµÄÇåµ¥
CATALOG Óû§¿É´æÈ¡µÄËùÓлù±íÇåµ¥
select from tab;
describeÃüÁî ÃèÊö»ù±íµÄ½á¹¹ÐÅÏ¢
describe dept
select 
from emp;
select empno,ename,job
from emp;
select from dept
order by deptno desc;
Âß¼­ÔËËã·û
= !=»ò<> > >= < <=
in
between value1 and value2
like
%
_
in null
not
no in,is not null
ν´ÊinºÍnot in
ÓÐÄÄЩְԱºÍ·ÖÎöÔ±
select ename,job
from emp
where job in ('clerk','analyst');
select ename,job
from emp
where job not in ('clerk','analyst');
ν´ÊbetweenºÍnot between
ÄÄЩ¹ÍÔ±µÄ¹¤×ÊÔÚ2000ºÍ3000Ö®¼ä
select ename,job,sal from emp
where sal between 2000 and 3000;
select ename,job,sal from emp
where sal not between 2000 and 3000;
ν´Êlike,not like
select ename,deptno from emp
where ename like 'S%';
(ÒÔ×ÖĸS¿ªÍ·)
select ename,deptno from emp
where ename like '%K';
(ÒÔK½áβ)
select ename,deptno from emp
where ename like 'W___';
(ÒÔW¿ªÍ·£¬ºóÃæ½öÓÐÈý¸ö×Öĸ)
select ename,job from emp
where job not like 'sales%';


Ïà¹ØÎĵµ£º

SQL ServerʹÓÃBulk Insert°ÑÒ»¸öÎı¾µ¼Èëµ½Êý¾Ý¿â

 
This is very common request recently – How to import CSV file into SQL Server? How to load CSV file into SQL Server Database Table? How to load comma delimited file into SQL Server? Let us see the solution in quick steps.
CSV stands for Comma Separated Values, sometimes also called Co ......

SQLÓÅ»¯

²éѯËÙ¶ÈÂýµÄÔ­ÒòºÜ¶à£¬³£¼ûÈçϼ¸ÖÖ£º
1¡¢Ã»ÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ)
2¡¢I/OÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£
3¡¢Ã»Óд´½¨¼ÆËãÁе¼Ö²éѯ²»ÓÅ»¯¡£
4¡¢ÄÚ´æ²»×ã
5¡¢ÍøÂçËÙ¶ÈÂý
6¡¢²éѯ³öµÄÊý¾ÝÁ¿¹ý´ó£¨¿ÉÒÔ²ÉÓöà´Î²éѯ£¬ÆäËûµÄ·½·¨½µµÍÊý¾ÝÁ¿£©
7¡¢Ëø»òÕßËÀËø(ÕâÒ²ÊDzé ......

sql DATEPART£¨£©º¯Êý

cdateÊÇdatetimeÀàÐ͵Ä×Ö¶Î
ͳ¼ÆÒ»ÄêµÄÈçÏÂ
 select datepart(yy,cdate) as 'Ô·Ý',sum(cmoney) from consumption group by datepart(yy,cdate)
ͳ¼ÆÒ»ÔµÄÈçÏÂ
 select datepart(mm,cdate) as 'Ô·Ý',sum(cmoney) from consumption where datepart(yy,cdate)=2009 group by datepart(mm,cdate)
ͳ¼ÆÒ»ÖÜ ......

SQL³£ÓÃÃüÁîʹÓ÷½·¨

 
(1) Êý¾Ý¼Ç¼ɸѡ£º
sql="select * from Êý¾Ý±í where ×Ö¶ÎÃû=×Ö¶ÎÖµ order by ×Ö¶ÎÃû [desc]"
sql="select * from Êý¾Ý±í where ×Ö¶ÎÃû like '%×Ö¶ÎÖµ%' order by ×Ö¶ÎÃû [desc]"
sql="select top 10 * from Êý¾Ý±í where ×Ö¶ÎÃû order by ×Ö¶ÎÃû [desc]"
sql="select * from Êý¾Ý±í where ×Ö¶ÎÃû in ('Öµ ......

SQL×¢Èë©¶´È«½Ó´¥

  Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚÕâ¸öÐÐÒµµÄÈëÃÅÃż÷²»¸ß£¬³ÌÐòÔ±µÄˮƽ¼°¾­ÑéÒ²²Î²î²»Æë£¬Ï൱´óÒ»²¿·Ö³ÌÐòÔ±ÔÚ±àд´úÂëµÄʱºò£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´úÂ룬¸ù¾Ý³ÌÐò·µ»ØµÄ½á¹û£¬»ñµÃijР......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ