Sql出错超时已过期查询数据的时候发现错误，请检查您的查询代
数据库服务器: linux as4 下安装的sybase12.5.4 在window XP下安装了sybase12.5.4的客户端，用Sybase Central v4.3创建了一个数据库lottery，并创建了game表 现在，我用sql Explorer(安装C++ Builder就有的)查询lottery库，可以登陆上去，也可以直接在敲sql语句来查询表， 比如“select * from game” 这些操作都是可以成功的。 但是，我想直接点开"Tables"的时候报错“[Sybase][ODBC Driver][Adaptive Server Enterprise]Stored...
by f1133000 - Sybase - 2008-03-24 18:11:44 阅读（2017） 回复（3）
我用sql语句建立数据库的时候，出现以下信息，小弟水平较低，看不懂，请大家指教 ！ Server Message: Number 1805, Severity 10 Line 1: CREATE DATABASE: allocating 51200 pages on disk 'tele114_def01' Server Message: Number 5005, Severity 10 Line 2: Extending database by 1024000 pages on disk tele114_run01 Server Message: Number 5005, Severity 10 Line 3: Extending database by 1024000 pages on di...
昨晚用BE备份一台服务器出错了，错误如附件： 报错说数据库前面多了一个斜杠？？！！我没写过什么斜杠啊，怎么会出现这个问题？ [ 本帖最后由 pet-dtg 于 2009-3-3 11:26 编辑 ]
我的sql语句怎么出错了“SELECT * FROM B_MS WHERE AJBS=273345” “SELECT * FROM B_MS ”没问题 是不是DB2数据库有问题呀
同事有个sql语句: 1.select count(*) FROM(SELECT CB.PK_STAT.GET_NET@JF(A.ROUTE_VALUE) REGION_CODE,NVL(COUNT(*),0) CNT FROM CB.HOME_BUSI_RECORD@JF A WHERE BIPCODE IN ('BIP1C001') and RESP_CODE!='0000' AND PROCESSTIME>SYSDATE-60/(24*60) GROUP BY CB.PK_STAT.GET_NET@JF(A.ROUTE_VALUE)) WHERE REGION_CODE=031 2.select count(*) FROM(SELECT CB.PK_STAT.GET_NET@JF(A.ROUTE_VALUE) REGION_CODE,NVL(COUNT(*),0)...
我在利用restore建立新数据库时出现The diskette drive door is open 我也查到了“sql0976n”的意思： sql0976N The diskette drive door is open. Explanation: The drive door for the database is open. The statement cannot be processed. User Response: Close the drive door and retry the operation. sqlcode: -976 sqlstate: 57021 可我不知道如何才能够实现“Close the drive door ”，请帮帮我好吗！谢谢！！！...
提示信息如下： 2005-11-24 16:21:14 - started process bpbrm (5500) 2005-11-24 16:21:14 - connecting 2005-11-24 16:21:14 - connected; connect time: 00:00:00 2005-11-24 16:21:30 - end writing none of the requested files were backed up(2) 2005-11-24 16:21:31 - Error bpsched(pid=5056) suspending further backup attempts for client TR12, policy fd, schedule Full because it has exceeded the configured num...
informix数据库 一个简单的sql select * from test1 where EXISTS ( SELECT 1 FROM test2 c WHERE c.rdn = test1.rdn ) 报错 245: Could not position within a file via an index. 144: ISAM error: key value locked 当我改成select * from test1 where not EXISTS ( SELECT 1 FROM test2 c WHERE c.rdn = test1.rdn ) 的时候可以执行。 我想知道，报这种错是因为什么原因，怎么排查
UPDATE request_detail SET FirChkCount= ( select count from request_detail where requestID=27 ) where requestID=27 这句话语法错误在那里了 请大家帮忙! [ 本帖最后由 yejr 于 2006-2-22 08:51 编辑 ]
