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

ij¹«Ë¾sqlÃæÊÔÌâ - MS-SQL Server / »ù´¡Àà

(1)ÓÐ3¸ö±ít1,t2,t3,ËûÃǾùÓÐÒ»¸öintÀàÐ͵ÄÁÐid,t1µÄ¼Ç¼Ϊ£¨1£©£¬t2µÄ¼Ç¼Ϊ£¨1£¬1£¬2£©,t3µÄ¼Ç¼Ϊ£¨1,1,1,2,2£©
·Ö±ðд³öÏÂÃæ2¸ösql Óï¾äµÄÖ´Ðнá¹û
select t1.id,t2.id,t3.id from t1 left join t2 on t1.id = t2.id left join t3 on t3.id = t2.id
select t1.id,t2.id,t3.id from t1 left join t2 on t1.id = t2.id ......

ÇóÒ»ÌõÅÅÐòSQL - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

±íA  
×Ö¶Î:fid,title
fid,title
1 ÕÅÈý
1 ÍõÎå
1 ÕÅËÄ
1 ÕŶþ
1 ÍõËÄ
3 ÕÅÈý·¢²¼
4 ÍõÎå·¢²¼
5 ÕÅÈý·¢²¼
6 ÕÅÈý·¢²¼2
fid=1µÄtitleÊÇÐÕÃû£¬²»µÈÓÚ1µÄtitleÊÇÐÅÏ¢ÇÒ°üº¬·¢²¼È˵ÄÐÕÃû£¬ÈçºÎÓÃSQLÁгö¸÷¸öÈ˵ķ¢²¼ÊýÁ¿µÝ¼õÅÅÐò
(²»Òª¸ß¹ÀÄãµÄººÓï±í´ïÄÜÁ¦»òÕßÎҵĺºÓïÀí½âÄÜÁ¦)
&nbs ......

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

Èç±íA
a b
1 wfs
1 abc
2 edf
2 fed
ÎÒÒªµÃµ½µÄ½á¹û
a b
1 wfsabc
2 edffed
ÇëÎÊÒªÈçºÎÐ´ÄØ£¿
SQL code:
/*
±êÌ⣺°´Ä³×ֶκϲ¢×Ö·û´®Ö®Ò»(¼òµ¥ºÏ²¢)
×÷Õߣº°®Ð¾õÂÞ.ع»ª(Ê®°ËÄê·çÓê,ÊØµÃ±ùɽѩÁ«»¨¿ª)
ʱ¼ä£º2008-11-06
µØµã£º¹ã¶«ÉîÛÚ
ÃèÊö£º½«ÈçÏÂÐÎʽµÄÊý¾Ý°´id×ֶκϲ¢value×ֶΡ£ ......

sql²éѯ,Å£ÈË¿ì½ø - MS-SQL Server / »ù´¡Àà

Óбítable1
SQL code:

uid time url
1 1 th
1 2 th
3 2 io
2 3 yu
4 1 th
1 8 io
2 9 yu
1 7 yu
Óû§ 1 ´Ó th ³öÀ´µÄʱ¼äÊÇ1ºÍ2£¬È»ºóÓÖÔÚʱ¼ä 7 ʱȥÁËyu ,ÔÚʱ¼ä 8 ʱȥÁËio£¬Òª²é³öËû´Ó1³öÀ´ºó×îÔçÈ¥ÁËÄǶù£¿½á¹û¾ ......

oracle ÈçºÎÔÚsqlÖÐʹÓñäÁ¿ - Oracle / ¿ª·¢

create or replace trigger......´¥·¢Æ÷
.....ÖмäÊ¡ÂÔ
begin
tablename:='CLTX_'||'201002';
insert into tablename(SBBH,FXBH,HPHM,HPZL,HPYS) values(:new.SBBH,:new.FXBH,:new.HPHM,:new.HPZL,:new.HPYS);
--ÈçºÎ°Ñ±äÁ¿tablename×÷Ϊ±íÃû·ÅÔÚintoºóÃæ£¬ÎÒÕâÑùÖ±½Ó¸úÔÚintoºóÃæ±¨´í
ora-04098 trigger ... is inva ......

¹ØÓÚSQLºÍASPÁ¬½ÓÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

¸÷λ´óϺÏÂÎçºÃ¹þ£¬ÎÒÓÖÀ´ÂÛ̳Çë½Ì´ó¼ÒÁË¡£ÎÒÃǹ«Ë¾×î½üÒª¸ü»»·þÎñÆ÷£¬Òª°ÑÀÏ·þÎñÆ÷ÉϵÄÒ»¸öWebÕ¾µãÒÆµ½Ð·þÎñÆ÷ÉÏ¡£Ð¡µÜÏȰÑÀÏ»úÆ÷ÉϵÄasp³ÌÐò¿½µ½Ð·þÎñÆ÷ÉÏ£¬ÓÃIIS´´½¨ÁËWEBÕ¾µã£¬ÓÖÓÃSQL»¹Ô­Á˱¸·ÝÊý¾Ý¿â£¨Îļþ¼ÐÀïÃæÃ»µÃ.mdfÎļþ£©ÏÖÔھͲ½¨SQLºÍASPµÄÁ¬½ÓÁË£¬ÎÒÔÚÍøÉÏ¿´µ½¼¸ÖÖ·½·¨£¬µ«ÊǾ­¹ýʵ¼ù¶¼ÎÞ·¨³É¹¦¡£ÎÊÌâ¶ ......
×ܼǼÊý:3315; ×ÜÒ³Êý:553; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [24] [25] [26] [27] 28 [29] [30] [31] [32] [33]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ