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

MSSQL ÈçºÎÍêÕûµÄ¸´ÖÆÒ»±í - MS-SQL Server / »ù´¡Àà

ÈçÌâ,Ö»Òª±í½á¹¹.²»ÐèÒªÊý¾ÝµÄ.±í½á¹¹¸´Öƺܺø´ÖÆ.µ«ÊǸú±íÓйصĴ¥·¢Æ÷,Ë÷ÒýµÈ,»¹ÓÐͳ¼ÆÐÅÏ¢Õâ¸öÊý¾ÝÄܹ»Ò»Æð¸´ÖÆ×ßÂð.¾ÍÊÇÁ½ÕűíÊÇһģһÑùµÄ.
select * into b from a

ÒýÓÃ
select * into b from a

ûÓÃ,ÕâÖ»ÊǸ´ÖƱíÄÚÊý¾Ý

ʹÓÃselect * into tab2 from tab1
µÄ·½Ê½£¬ÊDz»»áÁ¬Í¬Ö÷¼ü,Ë÷Òý,Ô¼Êø,´¥·¢Æ÷µÈÒ»Æð¸´¹ýÈ¥
Ö»ÊÇ´´½¨ÐÂ±í²¢×°ÔØÊý¾Ý¶øÒÑ

û·¨×Ó,ÄãµÃÁí½¨ÆäËüµÄ²¿·Ö

¶ÔÁË,Äã¿ÉÒÔÕâÑù
°ÑÏÖÓеıíÉú³É.SQL½Å±¾£¬Ôڽű¾Öн«ÏÖÓбíµÄ±íÃû¸ÄΪÄãÒªµÄÁÙʱ±í£¬ÔÙÔËÐиýű¾

¾ßÌåµÄ²Ù×÷¹ý³ÌÊÇ
ÓÒ»÷ÄãµÄ±íÃû
³ö²Ëµ¥, Ö¸Ïò"±àдÊý¾Ý¿â½Å±¾Îª"->"CREATE µ½"->"вéѯ±à¼­Æ÷´°¿Ú"
Äã»á¿´µ½³öÏÖÒ»¸öд°¿Ú, °ÑÕâÀï´úÂëÖÐËùÓеıíÃû¸Ä³ÉÄãÒª¸´ÖƵ½µÄ±íÃû


ÀûÓÃÔ­ÓбíÉú³É½Å±¾£¬Éú³ÉÐÂ±í£¬È»ºó°ÑÔ­ÓбíµÄÊý¾Ý²åÈ뵽бíÖÐ

select * into b from a where 1=2


select * into #tmp from tab
select * from #TMP from TAB WHERE 1<=2


Éú³É±íµÄSQL½Å±¾³öÀ´£¬ÕâÑùÊǶԱí½á¹¹µÄ×îºÃ±£´æ¡£
{{


Ïà¹ØÎÊ´ð£º

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Óï¾ä¡£ - Oracle / ¿ª·¢

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

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

phpÁ¬½ÓMSSQL Á¬²»ÉÏ - PHP / »ù´¡±à³Ì

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò, SQL state IM002 in SQLConnect in D:\0\msc\msc\tel.php on line 44
Í ......

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

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