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

Ö´ÐÐsqlÉúЧÎÊÌâ

°²×°ÐµÄÈí¼þ°üʱ£¬ÐèÒªÖ´ÐÐÏÂеÄsqlÉúЧ£¬Ã»Óб¨´í¡£µ«ÊÇÐ¶ÔØÈí¼þ°üµÄʱºò£¬ÐèÒª°Ñ¾ÉµÄsqlÖ´ÐÐÏÂÉúЧ£¬µ«Ò»Ö±Ö´Ðоͱ¨´í¡£Èç¹ûÖØ¸´Ö´ÐÐеÄsqlҲûÓÐÎÊÌâ¡£

  sqlplus -s /nolog < < SQLPLUS 

  set feedback off 

  connect ${DB_USER}/${DB_PASSWORD}@${DB_SERVER} 

  @ /etc/sql/schema/c_reporting.sql.pre; //¾ÉµÄsql

  commit; 

  quit; 

±¨´íÈçÏ£º 

CREATE OR REPLACE PACKAGE BODY a_pkg 

ERROR at line 1: 
ORA-00604: error occurred at recursive SQL level 1 
ORA-30036: unable to extend segment by 8 in undo tablespace 'ROLLBACK' 

Èç¹ûÊDZí¿Õ¼ä·ÖÅä²»¹»£¬ÎªÊ²Ã´Ö´ÐÐеÄsqlûÓÐÎÊÌâÄØ£¿
Õâ¸ö»¹ÓÐÎÊÌâ???
ËûÕâ¸öÊǸù¾ÝÄãµÄSQLÀ´µÄ...ÏÖÔÚÄãÓõij·Ïû±í¿Õ¼ä,
²¢²»ÊÇÊý¾Ý±í¿Õ¼ä
±ÈÈç˵ÁÙʱ±í¿Õ¼äÊÇÓÃÀ´ÅÅÐòʱºòʹÓõÄ.
ÎÒ¿´Ä㻹ÊÇÓÅ»¯ÄãµÄsql°É.°ÙÄãµÄc_reporting.sql.preÌù³öÀ´Èôó¼Ò¿´¿´¾ÍÖªµÀÁË

c_reporting.sql.preÊǸöpackage
Ð޸ĵÄÊÇÀïÃæµÄ¼¸¸öprocedure.
ÇëÎÊ Èç¹ûÏëÖ»ÖØÐÂÖ´ÐÐÏÂÐ޸ĵÄproceduce,²»ÊÇÖØÐÂÖ´ÐÐpackageµÄsql£¬¿ÉÒÔÂð£¿
лл

c_reporting.sql.pre֮ǰһֱִÐж¼Ã»ÓÐÎÊÌ⣬ÏÖÔÚÖ´ÐÐÍêеÄc_reporting.sql,È»ºóÔÙÖ´ÐÐc_reporting.sql.pre¾Í±¨´í£¬³·Ïû±í¿Õ¼äÒ»°ãʲôÇé¿öÏ»áÓõ½ÄØ£¿ ÇëÎÊ

ÒýÓÃ
Õâ¸ö»¹ÓÐÎÊÌâ???
ËûÕâ¸öÊǸù¾ÝÄãµÄSQLÀ´µÄ...ÏÖÔÚÄãÓõij·Ïû±í¿Õ¼ä,
²¢²»ÊÇÊý¾Ý±í¿Õ¼ä
±ÈÈç˵ÁÙʱ±í¿Õ¼äÊÇ


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

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

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

¹ØÓÚSQL Server Mobile Edition - .NET¼¼Êõ / C#

¹ØÓÚSQL Server Mobile Edition
ÓÃMicrosoft SQL Server2005 Management Studio Express9.00.3042.00´´½¨SQLCEÊý¾Ý¿âsqlmobile.sdf
ÔÚmobileϵͳÖÕ¶ËÉÏÓÃSQL Server Mobile Edition3.0Äܲ鿴sqlmobile.sdfÀï±íÊý¾Ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ