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

ÇóSQL severe 2000ÊÔÌâ¡£ - MS-SQL Server / »ù´¡Àà

ѧSQL SERVER 2000 Ò²ÓÐ10ÌìÁË¡£Ïë¸ãµãÌâÄ¿À´×Ô¼º×ö×ö¡£¿´¿´×Ô¼ºË®Æ½~£¡£¡£¡


¸ÕÈëÃÅ~£¡£¡£¡£¡£¡

SQL code:
´æÔÚÈçÏÂ3Õűí
S£¨Ñ§ºÅ£¨SNO)PK,ÐÕÃû£¨SNAME))£»
C£¨±àºÅ£¨CNO)PK,Ãû³Æ(CNAME),½Ìʦ£¨CTEACHER);
SC((ѧºÅ£¨SNO)FK,¿Î³Ì±àºÅ£¨CNO)FK)PK,³É¼¨£¨SCGRADE));
ÊÔÍê³ÉÒÔϲéѯ¹¦ÄÜ
ÎÊÌâ1¡¢ÕÒ³öѧ¹ý¡°1¡±ºÅ¿Î³ÌµÄѧÉúÐÕÃûºÍ³É¼¨
2¡¢ÕÒ³öûÓб¨¡°ÀîÃ÷¡±ÀÏʦµÄѧÉúµÄÐÕÃû
3¡¢Áгöÿ¸öѧÉúµÄƽ¾ù³É¼¨ºÍÐÕÃû
4¡¢ÁгöÓÐ2ÃÅÒÔÉÏ£¨º¬2ÃÅ£©¿Î³Ì²»¼°¸ñµÄѧÉúµÄÐÕÃû
5¡¢Áгöѧ¹ý¡°1¡±£¬¡°2¡±ºÅ¿Î³Ì³É¼¨µÄѧÉúµÄÐÕÃû
6¡¢Áгö¡°1¡±ºÅ¿Î³Ì³É¼¨¸ßÓÚ¡°2¡±ºÅ¿Î³Ì³É¼¨µÄѧÉú
7¡¢Áгö¡°1¡±ºÅ¿Î³Ì³É¼¨¸ßÓÚ¡°2¡±ºÅ¿Î³Ì³É¼¨µÄѧÉúµÄÐÕÃû£¬¡°1¡±ºÅ¿Î³Ì³É¼¨£¬¡°2¡±ºÅ¿Î³Ì³É¼¨ºÍÁ½ÃÅ¿ÎµÄÆ½¾ù³É¼¨


Õâ¸öÂÛ̳¾ÍºÜ²»´íÀ²£¡ÎÒÔÚÕâÀï´ýÁËÓÐ n ÌìÁË....

ÒýÓÃ
SQL code
´æÔÚÈçÏÂ3Õűí
S£¨Ñ§ºÅ£¨SNO)PK,ÐÕÃû£¨SNAME))£»
C£¨±àºÅ£¨CNO)PK,Ãû³Æ(CNAME),½Ìʦ£¨CTEACHER);
SC((ѧºÅ£¨SNO)FK,¿Î³Ì±àºÅ£¨CNO)FK)PK,³É¼¨£¨SCGRADE));
ÊÔÍê³ÉÒÔϲéѯ¹¦ÄÜ
ÎÊÌâ1¡¢ÕÒ³öѧ¹ý¡°1¡±ºÅ¿Î³ÌµÄѧÉúÐÕÃûºÍ³É¼¨
2¡¢ÕÒ³öûÓб¨¡°ÀîÃ÷¡±ÀÏʦµÄѧÉúµÄÐÕÃû
3¡¢Áгöÿ¸öѧÉúµÄƽ¾ù¡­¡­

ллÁË¡£¡£¡£ ÕâÖеÄ×ö¹ýÀàËÆµÄÁË¡£


Ïà¹ØÎÊ´ð£º

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

MYSQLµ÷¶ÈµÄÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ


3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......

¹ØÓÚVbÖÐsqlÓï¾äµÄд·¨£¨100·Ö£© - Java / Web ¿ª·¢

Çó¸övbÖеÄsqlÓï¾äµÄд·¨£¬´ÎsqlÓï¾äµÄÓ÷¨ÊÇ·ÖÒ³³ÌÐò
ÎÒдµÄÈçÏ£ºÆäÖÐAÊÇÓÃÀ´½ÓÊÕÿҳÏÔʾµÄ¼Ç¼µÄÌõÊý£¬BÊÇÓÃÀ´½ÓÊÕÏÔʾµÄµ±Ç°µÄÒ³Ãæ.
sqltext="select top A * from log where id not in(select top ( ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ