Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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,°ÑËü±£´æÆðÀ´²éѯ¾Í¿ÉÒÔ¸ü¼Ó·½±ãÁË¡£


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


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

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

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

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

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

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