Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ServerÌṩ³ÌÐò ¡£

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

SQL SERVER 2005 °²×°´íÎó½â¾öÁË~

½ñÌìÔÚһ̨Ðé»úÉϰ²×° sql server 2005£¬¾ÓÈ»±¨1´íÁË£¨ÎÞÓïÁË£¬×°Õâ¸ö¶«Î÷¶¼Åª²»ºÃ%>_<%£©¿ªÊ¼ÒÔΪÊÇÒòΪADÓòµÄÔ­Òò£¬ºóÀ´É¾µôÓòÓÖÖØ½¨Óò£¬È»ºóÔÙ×°£¬ÓÖ±¨2´í£¬ÓÚÊÇÎʱðÈËËÑË÷µÈµÈ£¬ÕÒµ½Ô­ÒòËµÒªÖØÐÂ×¢²áinstaller£¬×îÖÕ°²×°³É¹¦ÁË£¬º¦ÎÒ¼Ó°à۵쬏ßÐ˵ÄÊǰ²×°ºÃÀ²£¬¿ÉÊÇÎÒûÓÐŪÃ÷°×µ½µ×ÊÇɶԭÒòµ¼ÖÂsql°²×°²»ÁËÄØ£ ......

SQL SERVER ºÍEXCELµÄÊý¾Ýµ¼Èëµ¼³ö

 SQL SERVER ºÍEXCELµÄÊý¾Ýµ¼Èëµ¼³ö
1¡¢ÔÚSQL SERVERÀï²éѯExcelÊý¾Ý:
-- ======================================================
SELECT *
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\book1.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]
ÏÂÃæÊǸö²éÑ ......

JavaÊý¾Ý¿â°üjava.sql.*Ïê½â(jdk1.6)

1:Ó¦ÓóÌÐò²»ÔÙÐèҪʹÓà Class.forName() ÏÔʽµØ¼ÓÔØ JDBC Çý¶¯³ÌÐò¡£µ±Ç°Ê¹Óà Class.forName() ¼ÓÔØ JDBC Çý¶¯³ÌÐòµÄÏÖÓгÌÐò½«ÔÚ²»×÷Ð޸ĵÄÇé¿öϼÌÐø¹¤×÷¡£
2:ÐèҪעÒâÒÔÏÂÃüÁ
executeUpdate£ºÊÇ×î»ù´¡µÄÊý¾Ý¿âµÄ¸üС¢²åÈëºÍɾ³ý²Ù×÷¡£Ð§ÂʵÍÏ¡£   
executeQuery£ºÊÇ×î»ù´¡µÄÖ´ÐвéѯÓï¾ä£¬Í¬Ñù ......

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ºÅ