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

AccessÖд´½¨ÊÓͼ - MS-SQL Server / »ù´¡Àà

create view ±íÃû 
as

select a.a1,b.b1 from a inner join b on a.id=b.id

Õâ¸öÓï·¨ÔõôдÉÏÈ¥ÊÇ´íµÄÔÚAccessÀï
ACCESSºÃÏñ²»Ö§³Öcreate view
Äã¿ÉÒÔÔÚACCESSÖе¥»÷¡°ÊÓͼ¡±²Ëµ¥£¬Ñ¡Ôñ¡°SQLÊÓͼ¡±ÃüÁÕâÑùÔÚÆÁÄ»ÉϾͳöÏÖÁËÒ»¸öÎı¾¿ò£¬ÌîÈë:
select a.a1,b.b1 from a inner join b on a.id=b.id,°ÑËü±£´æÆðÀ´²éѯ¾Í¿ÉÒÔ¸ü¼Ó·½±ãÁË¡£

Ô­À´tony 
accessÒ²ºÜÀ÷º¦

ÒýÓÃ
Ô­À´tony
accessÒ²ºÜÀ÷º¦

·ÇÒ²£¬Ö»ÊÇÂÔÖªÒ»¶þ

ÒýÓÃ
ACCESSºÃÏñ²»Ö§³Öcreate view
Äã¿ÉÒÔÔÚACCESSÖе¥»÷¡°ÊÓͼ¡±²Ëµ¥£¬Ñ¡Ôñ¡°SQLÊÓͼ¡±ÃüÁÕâÑùÔÚÆÁÄ»ÉϾͳöÏÖÁËÒ»¸öÎı¾¿ò£¬ÌîÈë:
select a.a1,b.b1 from a inner join b on a.id=b.id,°ÑËü±£´æÆðÀ´²éѯ¾Í¿ÉÒÔ¸ü¼Ó·½±ãÁË¡£


±£´æÆðÀ´ÔÚË«»÷Ò²´ò²»¿ª°¡
Ìáʾ±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

ʹÓôøÓû§ÃûºÍÃÜÂëµÄACCESSÁ¬½Ó·½Ê½ - .NET¼¼Êõ / C#

ʹÓÃACCESS×î´óµÄÒþ»¼¾ÍÊDz»°²È«¡£½ñÌì¶ÔACCESSÊý¾Ý¿âÉèÖÃÁËÒ»¸öÃÜÂ룬±ØÐëʹÓÃÃÜÂë²ÅÄÜ´ò¿ª£¬µ«ÊÇÔÚ³ÌÐòÖÐÈ´ÎÞ·¨Á¬½ÓÊý¾Ý¿âÁË¡£´ó¼ÒÖªµÀʹÓÃÓû§ÃûºÍÃÜÂ룬ÈçºÎÁ¬½ÓACCESSÊý¾Ý¿â£¿Ã²ËÆACCESSµÄÓû§Ãû»¹²»ÖªµÀ£¿Ö»Öª ......

sql ÎÊÌâ - MS-SQL Server / »ù´¡Àà

ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......

ÓйØAccessÊý¾Ý¿â´æÈ¡µÄÎÊÌâ - C++ Builder / »ù´¡Àà

ÈçºÎ½«Ò»¸öListBoxÖеÄÊý¾Ý´æÔÚÊý¾Ý¿âÖеÄÒ»¸ö×Ö¶ÎÏÂÃæ£¬²¢ÇÒÿÌõ¼Ç¼µÄ×Ö·û´®¸öÊý²»Ò»¶¨ ÒÔ¼°ÈçºÎ´ÓÊý¾Ý¿âÖжÁÈ¡¸ÃListBoxÖеÄËùÓмǼ
C/C++ code:

//´æÈëÊý¾Ý¿â
void __fastcall TForm1::Button5Click(TO ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ