Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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È¡PostgreSQLÊý¾Ý¿â»ò±í´óС

ÔÚPostgreSQL8.1.3ÉÏ¿ÉÒÔwork
1. È¡Êý¾Ý¿â´óС
SELECT pg_size_pretty(pg_database_size('somedatabase')) As fulldbsize
2. È¡±í´óС
SELECT pg_size_pretty(pg_total_relation_size('someschema.sometable')) As fulltblsize, pg_size_pretty(pg_relation_size('someschema.sometable')) As justthetblsize
Ô­Ìù£º
......

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$]
ÏÂÃæÊǸö²éÑ ......

ÓÃSQLÓï¾äµÃµ½SQLServer µÄ±íÖеÄÁеÄÃèÊöÖµ

 select   case   when   c.colid=1   then   object_name(c.id)   else   ''   end   as   ±íÃû    
  ,c.name   as   ×Ö¶ÎÃû  
  ,t.name   Êý¾ÝÀàÐÍ  
  ,c.prec   as   ³¤¶È   ......

PB Êý¾Ý¿âÁ¬½ÓÒÔ¼°sqlÓï¾äÔËÐÐÐÅÏ¢·µ»Ø´úÂë½âÊÍ´óÈ«


Èç¹ûÒ»¸ö SQL Óï¾ä·¢ÉúÁË´íÎó£¬ÄÇô sqlca.sqlcode ½«ÊÇ·ÇÁãÖµ¡£
Èç¹û sqlca.sqlcode СÓÚ 0 ÄÇô¾ÍÊÇ·¢ÉúÁËijÖÖÑÏÖØµÄ´íÎó£¬ÏóÊý¾Ý¿â¶¨ÒåÓë²éѯ¶¨Òå²»Ò»Öµȣ®
Èç¹û´óÓÚ 0 ÔòÊÇͨ³£µÄ´íÎó£¬Ïó±í²»°üÀ¨ËùÒªÇóµÄÐеȣ®
sqlca.sqlcode == 0£¬³É¹¦
sqlca.sqlcode == -1 ʧ°Ü     £¨»ñÈ¡¾ßÌåʧ°ÜÐÅÏ¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ