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,°ÑËü±£´æÆðÀ´²éѯ¾Í¿ÉÒÔ¸ü¼Ó·½±ãÁË¡£ ±£´æÆðÀ´ÔÚË«»÷Ò²´ò²»¿ª°¡ Ìáʾ±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä
Ïà¹ØÎÊ´ð£º
type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jas ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡ Ëæ±ã¸ãÒ»D°æ°É£¬ ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓà 2000,2005¶¼ÕâÑù http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬ »òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡ ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡 ֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡ °ïUP ²Î¿¼:http://hi.baidu.com/toiota ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£» ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£» ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......