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


Ïà¹ØÎÊ´ð£º

¹ØÓÚACCESSºÍMSSQLµÄÎÊÌâ - Web ¿ª·¢ / ASP

ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ