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

sql Ö÷Íâ¼ü - MS-SQL Server / »ù´¡Àà

ÈçºÎij±íµÄ×ֶα»ÆäËü±íÒýÓã¬Ö÷Íâ¼ü¹Øϵ£¬ÄѵÀÒª±éÀúËùÓÐÓë¸Ã±íµÄ¸Ã×ֶν¨ÓÐÖ÷Íâ¼ü¹ØϵµÄ±íÂð£¿
ÈçºÎij±íµÄ×ֶα»ÆäËü±íÒýÓã¬...
Ëƺõ²¢Î´±í´ïÇå³þ,Óï·¨Ò²²»Í¨.

²»Çå³þÄãÏë¶Ô¸Ã×Ö¶Î×öʲô²Ù×÷£¿

Òª×öʲô

ÒýÓÃ
Òª×öʲô

²»ºÃÒâ˼£¬Ã»×¢Ò⣬
Ó¦¸ÃÊÇ£ºÈçºÎÅжÏij±íµÄ×ֶα»ÆäËü±íÒýÓã¬Ö÷Íâ¼ü¹Øϵ£¬ÄѵÀÒª±éÀúËùÓÐÓë¸Ã±íµÄ¸Ã×ֶν¨ÓÐÖ÷Íâ¼ü¹ØϵµÄ±íÂð£¿
Èç¹û¸Ã±íµÄÕâ¸ö×ֶα»ÆäËû±íÒýÓõĻ°£¬¾Í²»ÔÊÐí¶Ô¸Ã±íµÄÆäËü×ֶνøÐÐÐ޸IJÙ×÷

shuohua dou shuo ˵»°¶¼Ëµ²»Çå³þ °³FUÁË ÓÐ

ÒýÓÃ

ÒýÓà 3 Â¥ htl258 µÄ»Ø¸´:
Òª×öʲô

²»ºÃÒâ˼£¬Ã»×¢Ò⣬
Ó¦¸ÃÊÇ£ºÈçºÎÅжÏij±íµÄ×ֶα»ÆäËü±íÒýÓã¬Ö÷Íâ¼ü¹Øϵ£¬ÄѵÀÒª±éÀúËùÓÐÓë¸Ã±íµÄ¸Ã×ֶν¨ÓÐÖ÷Íâ¼ü¹ØϵµÄ±íÂð£¿
Èç¹û¸Ã±íµÄÕâ¸ö×ֶα»ÆäËû±íÒýÓõĻ°£¬¾Í²»ÔÊÐí¶Ô¸Ã±íµÄÆäËü×ֶνøÐÐÐ޸IJÙ×÷

Èç¹û¸Ã±íµÄÕâ¸ö×ֶα»ÆäËû±íÒýÓõĻ°£¬¾Í²»ÔÊÐí¶Ô¸Ã±íµÄÆäËü×ֶνøÐÐÐ޸IJÙ×÷
»¹ÓÐÕâÑùµÄÐèÇóѽ£¿
¾ßÌåÔõôÅжϱíµÄij¸ö×ֶα»ÆäËü±íµÄ×Ö¶ÎÒýÓÃÄØ£¿
ÍøÉϲé²é¿´£¬Ó¦¸ÃÓÐÏàÓ¦µÄ·½·¨

Èç¹û¸Ã±íµÄÕâ¸ö×ֶα»ÆäËû±íÒýÓõĻ°£¬¾Í²»ÔÊÐí¶Ô¸Ã±íµÄÆäËü×ֶνøÐÐÐ޸IJÙ×÷
½ö¹©²Î¿¼


Â¥Ö÷Äúû˵ÄãÏëÒª×öʲô


Ïà¹ØÎÊ´ð£º

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

ASPÒ³ÃæÎÞ·¨´ò¿ªÇóÖú£¡ - MS-SQL Server / »ù´¡Àà

¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......

sqlÓï¾äÎÊÌâ - Java / Web ¿ª·¢

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»áÓÐ ......

Accessͨ¹ýSqlÓï¾ä´´½¨Êý¾Ý¿â - .NET¼¼Êõ / C#

ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
  C=ID T="INTEGER" P=No M=No N="±àºÅ" Z=false,
  C=Ques ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ