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

Êý¾Ý¿âSQLÓï¾äʹÓã¨Ò»£©

  Êý¾Ý¿âsqlÓï¾äϵÁж¼ÊÇÒÔÏÂÃæµÄ±íΪ»ù´¡µÄ
1.       д³ö²½Öè4Öеĸ÷Ïî²Ù×÷µÄSQLÓï¾ä¡£
¢Ù ¸øÑ§Éú±íÔö¼ÓÒ»ÊôÐÔNation£¨Ãñ×壩£¬Êý¾ÝÀàÐÍΪVarchar£¨20£©£»
alter table Student add Nation varchar(20);
 
¢Ú ɾ³ýѧÉú±íÖÐÐÂÔöµÄÊôÐÔNation£»
alter table Student DROP COLUMN Nation ;
 
¢Û Ïò³É¼¨±íÖвåÈë¼Ç¼£¨”2001110”£¬”3”£¬80£©£»
insert into Grade (Sno,Cno,Gmark)values ('2001110','3',80);
 
¢Ü ÐÞ¸ÄѧºÅΪ”2001110”µÄѧÉúµÄ³É¼¨Îª70·Ö£»
update Grade set Gmark=70 where Sno='2001110';
 
¢Ý ɾ³ýѧºÅΪ”2001110”µÄѧÉúµÄ³É¼¨¼Ç¼£»
delete from Grade where Sno='2001110';
 
¢Þ ΪѧÉú±í´´½¨Ò»¸öÃûΪIX_ClassµÄË÷Òý¡£
create index IX_Class on Student(Sno);
 
SelectÓï¾äʹÓã¨Ò»£© 
Íê³ÉÒÔϸ÷Ïî²Ù×÷µÄSQLÓï¾ä£º
¢Ù     ÕÒ³öËùÓб»Ñ§ÉúÑ¡ÐÞÁ˵Ŀγ̺ţ»
select distinct Cno from Grade;
 
¢Ú     ÕÒ³ö01311°àŮѧÉúµÄ¸öÈËÐÅÏ¢£»
select * from Student where Clno='01311' and Ssex='Å®';
 
¢Û     ÕÒ³ö01311°à¡¢01312°àµÄѧÉúÐÕÃû¡¢ÐԱ𡢳öÉúÈÕÆÚ£»
select Sname, Ssex,2009-Sage Birthday from Student where Clno='01311' or Clno='01312';
 
¢Ü     ÕÒ³öËùÓÐÐÕÀîµÄѧÉúµÄ¸öÈËÐÅÏ¢£»
select * from Student where Sname like 'Àî%';
 
¢Ý     ÕÒ³öѧÉúÀîÓÂËùÔڰ༶µÄѧÉúÈËÊý£»
select Number from Class where Clno=(select Clno from Student where Sname='ÀîÓÂ');
 
¢Þ     ÕÒ³ö¿Î³ÌÃûΪ²Ù×÷ϵͳµÄƽ¾ù³É¼¨¡¢×î¸ß·Ö¡¢×îµÍ·Ö£»
select avg(Gmark)/ max(Gmark)/ min(Gmark) from Grade where Cno=(select Cno from Course where Cname='²Ù×÷ϵͳ' );
 
¢ß     ÕÒ³öÑ¡ÐÞÁ˿γ̵ÄѧÉúÈËÊý£»
select count(distinct Sno) from Grade ;
 
¢à ÕÒ³öÑ¡ÐÞÁ˿γ̲Ù×÷ϵͳµÄѧÉúÈËÊý¡£
select count(distinct Sno) from Grade where Cno=(select Cno from Course where Cname='²Ù×÷ϵͳ' );
select Óï¾äʹÓ㨶þ£©
 
1¡¢Íê³ÉÒÔϸ÷Ïî²Ù×÷µÄSQLÓï¾ä£º
¢Ù ÕÒ


Ïà¹ØÎĵµ£º

sql È¡·´

 update anketo1 set fb = substring('10',fb+1,1) WHERE id =5
ºóÀ´ÎÊÁËBM,BM˵ֱ½ÓÈ¡·´
update anketo1 set fb = ~ fb WHERE id =5
ÎÒ¸æËßÁËBMÓÃsubstringÒ²¿ÉÒÔ.
BM˵:"Õâ¼Ò»ïÀ÷º¦£¬ÕâÒ²ÄÜÏë³ö,ÕâÊôÓÚаÃÅÎ书."
×îºóÓÖÏëµ½ÓÃABSÈ¡¾ø¶ÔÖµÒ²¿ÉÒÔ
update anketo1 set fb = abs(fb-1)
ÎÒ¾õµÃ²»¹ÜÊÇʲôÎ书,ÄÜÖ ......

ÅäÖÃʹÓà SQL ServerÌṩ³ÌÐò ¡£

 ÅäÖÃʹÓà SQL ServerÌṩ³ÌÐò
 <configuration>
  <system.web> <-- ¸ü¸ÄÌṩ³ÌÐòÅäÖ㺠-->
    <membership defaultProvider="AspNetSqlProvider" />
  </system.web>
  <membership> <--ÅäÖÃÌṩ³ÌÐò -->
  <prov ......

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

SQL_ѧÉú

 
µÚÒ»²¿·Ö
µ¥±í²éѯ
ÀýÒ»£º²éѯȫÌåѧÉúµÄѧºÅÓëÐÕÃû
SELECT Sno,Sname
from Student;
Àý¶þ£º²éѯȫÌåѧÉúµÄÐÕÃû¡¢Ñ§ºÅ¡¢ËùÔÚϵ
SELECT Sname,Sno,Sdept
from Student;
ÀýÈý£º²éѯȫÌåѧÉúµÄÏêϸ¼Ç¼
SELECT *
from Student;
µÈ¼ÛÓÚ£º
SELECT *
from Student;
ÀýËÄ£º²éѯȫÌåѧÉúµÄÐÕÃû¼°Æä³öÉúÄê·Ý ......

OracleµÄSQL*PLUSÃüÁîµÄʹÓôóÈ«

 OracleµÄsql*plusÊÇÓëoracle½øÐн»»¥µÄ¿Í»§¶Ë¹¤¾ß¡£ÔÚsql*plusÖУ¬¿ÉÒÔÔËÐÐsql*plusÃüÁîÓësql*plusÓï¾ä¡£
¡¡¡¡
¡¡¡¡ÎÒÃÇͨ³£Ëù˵µÄDML¡¢DDL¡¢DCLÓï¾ä¶¼ÊÇsql*plusÓï¾ä£¬ËüÃÇÖ´ÐÐÍêºó£¬¶¼¿ÉÒÔ±£´æÔÚÒ»¸ö±»³ÆÎªsql bufferµÄÄÚ´æÇøÓòÖУ¬²¢ÇÒÖ»Äܱ£´æÒ»Ìõ×î½üÖ´ÐеÄsqlÓï¾ä£¬ÎÒÃÇ¿ÉÒÔ¶Ô±£´æÔÚsql bufferÖеÄsql Óï¾ä½ø ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ