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

mssqlµÄ¶à±í¹ØÁªÎÊÌâ - MS-SQL Server / »ù´¡Àà

a±íuid¡¢fidºÍb±íÖеÄid¹ØÁª£¬
ÈçºÎ²éѯa.uidºÍa.fid¶ÔÓ¦b±íÖеÄÏàÓ¦×ֶΡ£
SQL code:
select a.uid,a.fid,b.* from a,b where a.uid=b.id and a.fid=b.id


ÄãÊÇ˵b.idÊÇÓÉa.uid ºÍa.fid×é³ÉµÄ£¿
ÒªÊǵϰ£¬
b.id = a.uid + a.fid 
ÕâÑùÐв»

ÓеãÃÔºý

ÒýÓÃ
a±íuid¡¢fidºÍb±íÖеÄid¹ØÁª£¬
ÈçºÎ²éѯa.uidºÍa.fid¶ÔÓ¦b±íÖеÄÏàÓ¦×ֶΡ£

¾ßÌåÔõôÏÔʾ

select b.* from(
select uid as id from a union all
select fid from a) t join b on t.id=b.id

ÒýÓÃ
SQL code
select a.uid,a.fid,b.* from a,b where a.uid=b.id and a.fid=b.id

a.uidºÍa.fid¶ÔÓ¦ÔÚb.idÖеÄ×ֶΣ¬
¾Í±ÈÈç˵uidÊÇÖ¸Óû§µÄid,fidÊÇÖ¸Óû§µÄÅóÓÑid
ÎÒÏë²é³öÀ´Óû§µÄÐÕÃûºÍÓû§ÅóÓѵÄÐÕÃû£¬ÕâÑù²î¿Ï¶¨ÊDz»ÐеÄ

°Ñ±íµÄ½á¹¹£¬²âÊÔÊý¾Ý ¼°ÄãÒªµÄ½á¹û

¸æËßÎÒÃǰ¡

a
±í
id uid fid
1 1 2
2 3 5
b
id name
1 uid1
2 uid2
3 uid3
4 uid4
5 uid5
ÎÒÏëÒªµÃµ½
a.id = 1 ¶ÔÓ¦µÄuidµÄnameºÍfid¶ÔÓ¦µÄname
id uname fname
1 uid1 uid2
2 uid3 uid5

SQL code:

create table ta (id int,uid int,fid int)
insert into ta
select 1, 1, 2 u


Ïà¹ØÎÊ´ð£º

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

Çóһʱ¼ä±È½ÏµÄSQL Ö¸Áî - MS-SQL Server / »ù´¡Àà

±íÊý¾Ý
COL1 COL2 COL2 COL4 COL5
----------------------------------------------------------------------------------------------
2010-05-05 00:00 ......

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

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

C# SQL µÄUPDATETEXT ÎÊÌâ - .NET¼¼Êõ / C#

A±í ÓÐÁ½¸ö×ֶΠ
  id ΨһÊý×ÖÓò
  InfoTxt text ÀàÐÍ
 ÎÒÏÖÔÚÒª°Ñ id ²»ÊÇ14 µÄËùÓÐ InfoTxt×Ö¶Î Îı¾ºóÃæ ¶¼¼ÓÉÏ 'aaa' 
°´ÏÂÃæÖ´ÐÐÏÂÀ´ Ö»Óбí×îºóÒ»ÐмÓÉÏÁË 'aaa' ......

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ºÅ