Error Sql Error
Contents |
resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine
Sql Error 18456
Microsoft Student Partners ISV Startups TechRewards Events Community Magazine sql error codes Forums Blogs Channel 9 Documentation APIs and reference Dev centers Retired content Samples We’re
Oracle Sql Error
sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Transact-SQL Reference (Database Engine) Built-in Functions (Transact-SQL) System sql error mysql4 Functions (Transact-SQL) System Functions (Transact-SQL) @@ERROR (Transact-SQL) @@ERROR (Transact-SQL) @@ERROR (Transact-SQL) $PARTITION (Transact-SQL) @@ERROR (Transact-SQL) @@IDENTITY (Transact-SQL) @@PACK_RECEIVED (Transact-SQL) @@ROWCOUNT (Transact-SQL) @@TRANCOUNT (Transact-SQL) BINARY_CHECKSUM (Transact-SQL) CHECKSUM (Transact-SQL) COMPRESS (Transact-SQL) CONNECTIONPROPERTY (Transact-SQL) CONTEXT_INFO (Transact-SQL) CURRENT_REQUEST_ID (Transact-SQL) CURRENT_TRANSACTION_ID (Transact-SQL) DECOMPRESS (Transact-SQL) ERROR_LINE (Transact-SQL) ERROR_MESSAGE (Transact-SQL) ERROR_NUMBER (Transact-SQL) mysql error ERROR_PROCEDURE (Transact-SQL) ERROR_SEVERITY (Transact-SQL) ERROR_STATE (Transact-SQL) FORMATMESSAGE (Transact-SQL) GET_FILESTREAM_TRANSACTION_CONTEXT (Transact-SQL) GETANSINULL (Transact-SQL) HOST_ID (Transact-SQL) HOST_NAME (Transact-SQL) ISNULL (Transact-SQL) ISNUMERIC (Transact-SQL) MIN_ACTIVE_ROWVERSION (Transact-SQL) NEWID (Transact-SQL) NEWSEQUENTIALID (Transact-SQL) ROWCOUNT_BIG (Transact-SQL) SESSION_CONTEXT (Transact-SQL) SESSION_ID (Transact-SQL) XACT_STATE (Transact-SQL) TOC Collapse the table of content Expand the table of content This documentation is archived and is not being maintained. This documentation is archived and is not being maintained. @@ERROR (Transact-SQL) Other Versions SQL Server 2012 THIS TOPIC APPLIES TO: SQL Server (starting with 2008)Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse Returns the error number for the last Transact-SQL statement executed. Transact-SQL Syntax ConventionsSyntax Copy -- Syntax for SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse @@ERROR Return TypesintegerRemarksReturns 0 if the previous Transact-SQL statement encountered no errors.Returns an error number if the previous statement encountere
SQL Error Messages ] Go to: SQLCODE 0 and 100 SQLCODE -400 Retrieving SQL Message Texts Table of SQL Error Codes and Messages Search: The table below lists the SQL numeric error codes and their error http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RERR_sql messages. These codes are returned as the SQLCODE variable value. Note: While this document lists error codes as negative values, JDBC and ODBC clients always receive positive values. For example, if an ODBC or JDBC application returns error code 30, look up error code -30 in this table. SQLCODE 0 and 100 There are two SQLCODE values that do not represent an SQL error: SQL Error Codes 0 and 100 Error Code sql error Description 0 Successful Completion 100 No (more) data SQLCODE=0 indicates successful completion of an SQL operation. For a SELECT statement, this usually means the successful retrieval of data from a table. However, if the SELECT performs an aggregate operation, (for example: SELECT SUM(myfield)) the aggregate operation is successful and an SQLCODE=0 is issued even when there is no data in myfield; in this case SUM returns NULL and %ROWCOUNT=1. SQLCODE=100 indicates error sql error that the SQL operation was successful, but found no data to act upon. This can occur for a number of reasons. For a SELECT these include: the specified table contains no data; the table contains no data that satisfies the query criteria; or row retrieval has reached the final row of the table. For an UPDATE or DELETE these include: the specified table contains no data; or the table contains no row of data that satisfies the WHERE clause criteria. In these cases %ROWCOUNT=0. SQLCODE -400 The SQLCODE -400 error Fatal error occurred is a general error. It is generated when a more specific SQLCODE error code is not available. Retrieving SQL Message Texts To determine the meaning of an SQLCODE numeric code, use the following Caché ObjectScript statement: WRITE "SQLCODE=",$SYSTEM.SQL.SQLCODE(-nnn) This SQLCODE() method can also be called as a stored procedure from ODBC or JDBC: %SYSTEM.SQL_SQLCODE(-nnn). When possible (usually at SQL compile time), error messages include the name of the field, table, view, or other element that caused the error. Placeholders for these names are shown using the