Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¡¢Áгöÿ¸öѧÉúµÄƽ¾ù¡­¡­

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


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸ö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Ò ......

Çë½ÌSQLÓï¾ä²éѯÎÊÌ⣿ - MS-SQL Server / »ù´¡Àà

ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä  
  Id value state dattime  
  101 32.3 0 ......

¹ØÓÚ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ºÅ