General SQL Server error: Check messages from the SQL Server

tzxueqing 2006-10-17 09:07:38

在insert 数据库时出现该错误,该表有个字段类型为numeric

...全文

1225 1 打赏收藏转发到动态举报

写回复

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

hobbylu 2006-10-17

打赏
举报

回复

先检查日志，还需要描述具体错误现象，越详细越好

Oracle SQL Developer, v1.5.0.54.40 Release Notes 完整版下载：http://www.oracle.com/technology/global/cn/software/products/sql/index.html 1. Known Issues 1.1 General - Print prints only one page that is a truncation of the current tab. - Can't invoke SQL*Plus on Windows 2003. - The menu item, and right-click off a Connection node, for invoking SQL*Plus does not work with connections whose passwords are not persisted. 1.2 Connections - Cannot connect to remote database as OPS$ account. 1.3 Browse - If connected as sys with sysdba role, Types node displays built in data-types (e.g. BLOB, DATE, DECIMAL, etc.) If clicked on, will only see "create or replace". 1.4 Creating and Modifying Objects - Editing Triggers - If you have comments before the 'BEGIN' they will be lost if you edit. You will see when you click edit that they will not be there. To preserve them, they need to be below the BEGIN or you will need to edit via the SQL Worksheet. 1.5 Table > Data - Tables > Your_Table > Data - PageUp and PageDown buttons not working correctly if cursor is in the rownum column. 1.6 Export - Cannot export if result set contains duplicate column names. 2. Workarounds 2.1 To disable Code Insight Run SQL Developer from a command line using the following statement: Windows : sqldeveloper -J-Dsdev.insight=false Linux or Mac: Run sh sqldeveloper -J-Dsdev.insight=false or edit sqldeveloper.conf and add "AddVMOption -J-Dsdev.insight=false" 2.2 If DDL tab is null for all objects in a Connection Your dbms_metadata might be loaded incorrectly. If this statement fails when executed in a SQL Worksheet against the Connection select dbms_metadata.get_ddl('TABLE',table_name , user ) from user_tables; You need to reload $ORACLE_HOME/rdbms/admin/catmeta.sql 2.3 If Snippets are not accessible You may have not done a clean install. SQL Developer needs to be installed into a clean directory, not over a previous release. 3. Accessibility Issues The following is a li

Mysql想插入数据有点问题代码是： sample_cmd = 'SELECT s.InfoId, s.UserName, s.Disease , s.Defined5, r.InfoId\ InfoId1,r.ReportDate FROM dbo.J_SampleRegister s inner \ join (SELECT distinct InfoId,ReportDate,Id FROM dbo.J_Report)\ r on s.InfoId=r.InfoId WHERE s.Di

错误信息: ERROR: DB-Library error: DB #: 20018, DB Msg: General SQL Server error: Check messages from the SQL Server 1.错误代码 create foreign table xx.xxxx( xxxx, xxxx ) server mssql_svr options (table 'baaa'); 原因: 脚本是通过某工具自动转化的,options中的表应为 ‘aaa’ 正确代码 c

目录安装pymssql模块实现连接连接到SQL server 连接查询数据遇到的问题 Adaptive Server 不可用或不存在 Check messages from the SQL Server\n" 记录一下：用到的模块是： pymssql 安装pymssql模块先在pycharm安装其模块：实现连接这里贴上pymssql的官方文档：pymssql module reference — pymssql 2.1.4 document...

成功解决：(156, b"Incorrect syntax near the keyword ‘group’.DB-Lib error message 20018, severity 15:\nGeneral SQL Server error: Check messages from the SQL Server\n")

2,598

社区成员

25,609

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章