SQL SERVER 系统函数 (Transact-SQL)

最新推荐文章于 2023-07-25 10:15:05 发布

转载最新推荐文章于 2023-07-25 10:15:05 发布 · 457 阅读

文章标签：

31 篇文章

订阅专栏

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

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