sql server2005Êý¾Ý¿â¼ÓÃÜ - MS-SQL Server / »ù´¡Àà
×öÁËÒ»¸ö¹ÜÀí³ÌÐò
ÏëÈÃÊý¾Ý¿âÓиöÃÜÂë
Ö»ÓÐÊäÈëÃÜÂë²ÅÄܽøÈëÊý¾Ý¿âÖÐ
½øÐÐÐ޸ģ¬
µÚÒ»´Î×öÊý¾Ý¿â£¬ÇëÎÊ´ó¼ÒÈçºÎ¸øÊý¾Ý¿â»òÕß
ÆäÖеıíÉèÖÃÃÜÂ룬ÒÔ·À±ðÈ˵ǽ
1Â¥µÄÄÜÏêϸЩÂð£¿
ûÓп´¶®
º¹ ²»ÊÇÓÀÉú¸çµÄÒâ˼°É
Â¥Ö÷²»±Ø×ö³ÌÐòµÄ£¬sql×Ô´ø·þÎñÆ÷½ÇÉ«ºÍÊý¾Ý¿â½ÇÉ«£¬Äã¿ÉÒÔÌí¼Ó¸öÓû§£¬ÔÚ·þÎñÆ÷½ÇÉ«ÀïÄÜ¿ØÖÆËûÃǶԱí²Ù×÷µÄȨÏÞ
Ïà¹ØÎÊ´ð£º
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
select o_customer,o_price from orders having o_price >=avg(o_price)
select o_customer,o_price from orders where o_price >=(select avg(o_price) from orders)
ÎҸоõûÓÐÇø±ð°¡£¬ÔõôÔÚmysql»áÓÐ ......
A±í ÓÐÁ½¸ö×Ö¶Î
id ΨһÊý×ÖÓò
InfoTxt text ÀàÐÍ
ÎÒÏÖÔÚÒª°Ñ id ²»ÊÇ14 µÄËùÓÐ InfoTxt×Ö¶Î Îı¾ºóÃæ ¶¼¼ÓÉÏ 'aaa'
°´ÏÂÃæÖ´ÐÐÏÂÀ´ Ö»Óбí×îºóÒ»ÐмÓÉÏÁË 'aaa' ......
ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
C=ID T="INTEGER" P=No M=No N="񅧏" Z=false,
C=Ques ......