SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Books Online for SQL Server 2012

Database Engine

Transact-SQL Reference (Database Engine)

Built-in Functions (Transact-SQL)

System Functions (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)

CONNECTIONPROPERTY (Transact-SQL)

CONTEXT_INFO (Transact-SQL)

CURRENT_REQUEST_ID (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 (Transact-SQL)

GETANSINULL (Transact-SQL)

GET_FILESTREAM_TRANSACTION_CONTEXT (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)

XACT_STATE (Transact-SQL)

Minimize

4 out of 5 rated this helpful - Rate this topic

System Functions (Transact-SQL)

SQL Server 2012

SQL Server 2005

The following system functions perform operations on and return information about values, objects, and settings in SQL Server.

$PARTITION	ERROR_SEVERITY
@@ERROR	ERROR_STATE
@@IDENTITY	FORMATMESSAGE
@@PACK_RECEIVED	GETANSINULL
@@ROWCOUNT	GET_FILESTREAM_TRANSACTION_CONTEXT
@@TRANCOUNT	HOST_ID
BINARY_CHECKSUM	HOST_NAME
CHECKSUM	ISNULL
CONNECTIONPROPERTY	ISNUMERIC
CONTEXT_INFO	MIN_ACTIVE_ROWVERSION
CURRENT_REQUEST_ID	NEWID
ERROR_LINE	NEWSEQUENTIALID
ERROR_MESSAGE	ROWCOUNT_BIG
ERROR_NUMBER	XACT_STATE
ERROR_PROCEDURE

Reference

Built-in Functions (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.