Ö´ÐÐ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·Ïû±í¿Õ¼ä, ²¢²»ÊÇÊý¾Ý±í¿Õ¼ä ±ÈÈç˵ÁÙʱ±í¿Õ¼äÊÇ
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ' select cast(convert(numeric(18,2),1275674000000/100000000)as real) ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
protected void btnLogin_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login"); &nb ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£© tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname ½á¹û£º µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
¹ØÓÚSQL Server Mobile Edition ÓÃMicrosoft SQL Server2005 Management Studio Express9.00.3042.00´´½¨SQLCEÊý¾Ý¿âsqlmobile.sdf ÔÚmobileϵͳÖÕ¶ËÉÏÓÃSQL Server Mobile Edition3.0Äܲ鿴sqlmobile.sdfÀï±íÊý¾Ý ......