Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 / »ù´¡Àà

A£¬ id, attributes
  1£¬ 1001,12;1002,45
  2, 1002,14;1003,54
B, id,name
  1001,ÎÞµÐ
  1002£¬Èõ
  1003£¬Ç¿º·
AÖÐattributes×Ö¶ÎÊÇÓжà¸öBÊý¾Ý±íµÄidºÍÖµ×é³ÉµÄ£¬
ÏÖÔÚÎÒÏëÔÚselect,µÄʱºò°ÑËûµÄnameºÍÖµÒ»ÆðÏÔʾ£»
  1£¬ÎÞµÐ,12;Èõ,45
  2, Èõ,14;Ç¿º ......

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

ÎÒÓÐusers±í£¬ÀïÃæÓÐuserid,username£¬pwdµÈÁÐ,Õâ¸ö±íÀïÓкܶàÌõÊý¾ÝÁË
ÏÖÓÐtuijian±í£¬ÀïÃæÓÐtuijianid,zhuceid,zhucenameµÈÁУ¬Õâ¸ö±íÊÇÐÂ±í£¬ÎÞÊý¾Ý
ÏÖÔÚÎÒÏ뽫users±íÖеÄuserid,username(ÕâÁ½ÁеÄËùÓÐÖµ)ÕâÁ½¸öÁеÄÊý¾Ý¸´ÖƵ½tuijian±íÖеÄzhuceid,zhucename
ÇëÎʸÃSQLÓï¾äÔõôд°¡
SQL code:
insert tuijian(zh ......

ÓйØhibernateÔ­Éúsql²éѯ - Java / Java EE

ÎҵıíΪ£ºtesttable
×Ö¶ÎΪ£ºid int not,name decimal(10,2);
²åÈëµÄ²âÊÔÊý¾ÝΪ£º
1,10.2
SQLQuery query = con.createSQLQuery("select * from testtable");
List products = query.list();
±¨´íÈçÏ£º
2010-5-20 15:18:17 org.apache.catalina.core.StandardWrapperValve invoke
ÑÏÖØ: Servlet.servic ......

¹ØÓÚSQLÓï¾äORµÄÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
·½·¨2£º
ͨ¹ýÑ­»·100´Î£¬Ã¿´ÎÖ´ÐÐÒ»¸öNameÌõ¼þ£¬Ö´ÐÐ100¸öSQLÓï¾ä
Select * from tmp_table where Name=' ......

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ - MS-SQL Server / »ù´¡Àà

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ

¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿

Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ

º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£

sqlserverûÔõôÓùý¡£Ò²Ã»Óа²×°¡£¡£¡£¡£

¸Õ°²×°ÁËMSsql2005°ÑÏÂÏÂÀ´µÄMDFµ¼ÈëÁË¡£¡£Ð»Ð»°¡
......

oracle PL/SQL³ÌÐò¿éÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

±àдPL/SQL³ÌÐò¿éShowInfo£¬¸ø¶¨Ò»¸öÔ±¹¤ºÅ¾Í¿ÉÒÔÏÔʾÆäÐÕÃû¡¢ÐÔ±ðµÈÐÅÏ¢,
Èç¹û¸ÃÔ±¹¤²»´æÔÚÔòÏÔʾ¡®¶Ô²»Æð£¬Ã»ÓдËÔ±¹¤£¡¡¯
 ÇëÎÊÉÏÃæÕâµÀÌâÕâôд£¿£¿¸Õѧoracle¶ÔºÜ¶à¶¼²»ÊǺܶ®£¬Ï£ÍûÄܹ»Ïêϸ½âÊÍ£¡Ð»Ð»
if(v is not null)then
dbms_output.put_line('¸ÃÔ±¹¤²»´æÔÚ');

Õâ¸öÎÊÌâ¼ÇµÃǰ¼¸ÌìÓÐÈËÎʹý

×Ô¼ ......
×ܼǼÊý:3315; ×ÜÒ³Êý:553; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [21] [22] [23] [24] 25 [26] [27] [28] [29] [30]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ