Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : sql

ÇóSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

Óбí
¶ùͯÐÕÃû ³öÉúÈÕÆÚ ½ÓÖÖÒßÃç ½ÓÖÖʱ¼ä
Àî¸ÖÑó 2010-01-29 A1B1F1F2 101U104O101U1033
¿õºÆÓî 2010-01-26 A1B1F1 101Q104N101Q
³Ì³É 2010-01-03 A1B1F1F2 1013103M1013
½¯ÁÖ¾ù 2010-01-03 A1B1B2F1F2{1 1014103M104M10141024104M
ÉòÑîºÆ 2010-01-03 A1B1B2F1F2{1 1014 ......

Õâ¾äsqlʲôÒâ˼ - MS-SQL Server / »ù´¡Àà

select * from tb t where (select count(1) from tb where id<=t.id) between 10 and 20
Õâ¾äsqlÊÇÈçºÎÖ´ÐÐµÄ Ò²¾ÍÊÇÔ­ÀíÊÇʲô£¿ ÎÒ¿´²»¶®£¡~~~
µ±Ç°¼Ç¼ȥִÐÐ (select count(1) from tb where id<=t.id) µÄ½á¹ûÔÚ10-20Ö®¼ä¡£

½¨ÒéÄãÏÈ×Ô¼ºÊÔ׎âÊÍÒ»ÏÂÕâ¸öÓï¾ä£¬·ñÔò±ðÈËÒ²¸ù±¾²»ÖªµÀÄãÄ¿Ç°ÒѾ­¶®ÁËʲô£ ......

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

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

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

Òª×öʲô

ÒýÓÃ
Òª×öʲô
²»ºÃÒâ˼£¬Ã»×¢Ò⣬
Ó¦¸ÃÊÇ£ºÈçºÎÅжÏij±íµÄ×ֶα»ÆäËü±íÒýÓã¬Ö÷Íâ¼ü¹Øϵ£¬ÄѵÀÒª±é ......

ÒªÈçºÎѧºÃsql - MS-SQL Server / »ù´¡Àà

ÎÒÏÖÔÚ»áһЩ»ù±¾µÄsqlÓï·¨£¨Ôöɾ¸Ä²é,´æ´¢¹ý³Ì,ÊÂÎñ£©
²»ÖªµÀÒªÈçºÎÉîÈëѧϰsql,²»ÖªµÀ ÓÐûÓÐʲôºÃµÄ½¨Òé~~~
ÉÏÂÛ̳¿´Ìû

»ù±¾µÄ»áÁËÒÔºó¾Í¿ÉÒÔÂòµãÉîÈëµÄÊé¿´ÁË ±ÈÈç¼¼ÊõÄÚÄ»

Ö±½Ó¿´ÊéÄã»áºÜÀÛ£¬Ô½¿´Ô½ÔΡ£Îҵľ­ÑéÊÇÖ±½Óѧϰ±ðÈËÏֳɵĶ«Î÷¡£±ÈÈç¹Ü¼ÒÆŵÈÈí¼þµÄ´æ´¢¹ý³Ì£¬ÀïÃæдµÄºÜʵÓ㬻ù±¾ÉÏÊéÉÏдµÄ¶«Î÷£¬ ......

ÇóSqlÓï¾äÒ»Ìõ - MS-SQL Server / »ù´¡Àà

Ò»¸ö±í a £¬×öÁËÒ»¸öa ±íµÄ ±¸·Ý È¡Ãû a_bak£¨×ֶζ¼ÊÇÏàͬµÄ£©¡£
ÏÖÔÚ ²»Ð¡ÐÄ°Ñ a ±íijһÌõ¼Ç¼¸øɾ³ýÁË£¬µ«ÊÇ Ò²²åÈë a_bak±íÖУ¬
ÏÖÔÚ ÈçºÎ°Ñ a_bak ±íÖÐÄÇÒ»Ìõ¼Ç¼ ÔÙ²åÈë a±íÖÐ....???
ÓÉÓÚa±íÖÐ µÄ×ֶηdz£µÄ¶à£¬
insert Ä¿±ê±íÃû£¨×Ö¶ÎÁÐ±í£© select ×Ö¶ÎÁбí from Ô´±íÃû where ¿½±´Ìõ¼þ&nb ......

jspÖÐsqlǶÌײéѯµÄÎÊÌâ - Web ¿ª·¢ / JavaScript

ÓÐÁ½ÕÅ±í£º
tb_topic (Tid,U_id,T_title,T_content,T_submittime,T_rq);Ö÷¼ü£ºU_id¡£T_rqÊǸÃÖ÷ÌâµÄ»Ø¸´Êý¡£
tb_response(Rid,Tid,R_author,R_submittime,R_content);Ö÷¼üÊÇ£ºRid¡£
ÏëʵÏÖÒ»¸öÑ­»·Í³¼ÆÊä³ö¡£¸ù¾ÝTid´Ó±ítb_responseÖлñµÃËùÓлظ´¹ýtb_topicÖеÄÖ÷ÌâµÄÓû§ÃûR_author£¬
ÔÙ¸ù¾ÝR_author»ñµÃ¸ÃÓû§ÔÚtb_t ......
×ܼǼÊý:3315; ×ÜÒ³Êý:553; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [6] [7] [8] [9] 10 [11] [12] [13] [14] [15]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ