Msdn Sql @@error
Contents |
resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners db2 sql error ISV Startups TechRewards Events Community Magazine Forums Blogs Channel sql server @@error message 9 Documentation APIs and reference Dev centers Samples Retired content We’re sorry. The content you sql server error code -2146232060 requested has been removed. You’ll be auto redirected in 1 second. Transact-SQL Reference (Database Engine) Built-in Functions (Transact-SQL) System Functions (Transact-SQL) System Functions t-sql @@error (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) ERROR_PROCEDURE (Transact-SQL) ERROR_SEVERITY (Transact-SQL) ERROR_STATE (Transact-SQL) FORMATMESSAGE
Mssql Error
(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 encountered an error. If the error was one of the errors in the sys.messages catalog
Microsoft Tech Companion App Microsoft Technical Communities Microsoft Virtual Academy Script Center Server and Tools Blogs TechNet Blogs TechNet Flash Newsletter TechNet Gallery TechNet Library TechNet Magazine TechNet
Ms Sql Error
Subscriptions TechNet Video TechNet Wiki Windows Sysinternals Virtual Labs Solutions Networking Cloud sql error 803 and Datacenter Security Virtualization Downloads Updates Service Packs Security Bulletins Windows Update Trials Windows Server 2016 System Center 2016 @@rowcount in sql server Windows 10 Enterprise SQL Server 2016 See all trials » Related Sites Microsoft Download Center TechNet Evaluation Center Drivers Windows Sysinternals TechNet Gallery Training Training Expert-led, virtual classes Training Catalog Class https://msdn.microsoft.com/en-us/library/ms188790.aspx Locator Microsoft Virtual Academy Free Windows Server 2012 courses Free Windows 8 courses SQL Server training Microsoft Official Courses On-Demand Certifications Certification overview MCSA: Windows 10 Windows Server Certification (MCSE) Private Cloud Certification (MCSE) SQL Server Certification (MCSE) Other resources TechNet Events Second shot for certification Born To Learn blog Find technical communities in your area Support Support options For business For https://technet.microsoft.com/en-us/library/ms190193(v=sql.105).aspx developers For IT professionals For technical support Support offerings More support Microsoft Premier Online TechNet Forums MSDN Forums Security Bulletins & Advisories Not an IT pro? Microsoft Customer Support Microsoft Community Forums United States (English) Sign in Home Library Wiki Learn Gallery Downloads Support Forums Blogs We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Accessing and Changing Database Data Procedural Transact-SQL Handling Database Engine Errors Handling Database Engine Errors Using @@ERROR Using @@ERROR Using @@ERROR Retrieving Error Information in Transact-SQL Using TRY...CATCH in Transact-SQL Using RAISERROR Using PRINT Using @@ERROR Handling Errors and Messages in Applications 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. Using @@ERROR The @@ERROR system function returns 0 if the last Transact-SQL statement executed successfully; if the statement generated an error, @@ERROR returns the error number. The value of @@ERROR changes on the completion of each Transact-SQL statement.Because @@ERROR gets a new value when every Transact-SQL statement completes, process @@ERROR
resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Samples Retired content https://msdn.microsoft.com/en-us/library/ms164086.aspx We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Errors and Events Reference Database Engine Events and Errors Understanding Database Engine Errors Understanding Database Engine Errors Database Engine Error Severities Database Engine Error Severities Database Engine Error Severities Database Engine Error Severities TOC Collapse the table of content Expand the table of content This documentation is archived and is not sql error being maintained. This documentation is archived and is not being maintained. Database Engine Error Severities SQL Server 2016 Other Versions SQL Server 2014 SQL Server 2012 Applies To: SQL Server 2016When an error is raised by the SQL Server Database Engine, the severity of the error indicates the type of problem encountered by SQL Server.Levels of SeverityThe following table lists and describes the severity levels of the msdn sql @@error errors raised by the SQL Server Database Engine.Severity levelDescription0-9Informational messages that return status information or report errors that are not severe. The Database Engine does not raise system errors with severities of 0 through 9.10Informational messages that return status information or report errors that are not severe. For compatibility reasons, the Database Engine converts severity 10 to severity 0 before returning the error information to the calling application.11-16Indicate errors that can be corrected by the user.11Indicates that the given object or entity does not exist.12A special severity for queries that do not use locking because of special query hints. In some cases, read operations performed by these statements could result in inconsistent data, since locks are not taken to guarantee consistency.13Indicates transaction deadlock errors.14Indicates security-related errors, such as permission denied.15Indicates syntax errors in the Transact-SQL command.16Indicates general errors that can be corrected by the user.17-19Indicate software errors that cannot be corrected by the user. Inform your system administrator of the problem.17Indicates that the statement caused SQL Server to run out of resources (such as memory, locks, or disk space for the database) or to exceed some limit set by the system administrator.18Indicates a problem in the Database Engine software,