Fungsi Sistem (Transact-SQL)

Berlaku untuk:Titik akhir analitik SQL Server Azure SQL Managed Instance SQL di Microsoft FabricWarehouse di Microsoft Fabric

Fungsi sistem berikut melakukan operasi pada dan mengembalikan informasi tentang nilai, objek, dan pengaturan di SQL Server.

$PARTITION

ERROR_PROCEDURE

@@ERROR

ERROR_SEVERITY

@@IDENTITY

ERROR_STATE

@@PACK_RECEIVED

FORMATMESSAGE

@@ROWCOUNT

GET_FILESTREAM_TRANSACTION_CONTEXT

@@TRANCOUNT

GETANSINULL

BINARY_CHECKSUM

HOST_ID

CHECKSUM

HOST_NAME

KOMPRES

ISNULL

CONNECTIONPROPERTY

ISNUMERIC

CONTEXT_INFO

MIN_ACTIVE_ROWVERSION

CURRENT_REQUEST_ID

ID BARU

CURRENT_TRANSACTION_ID

NEWSEQUENTIALID

DEKOMPRESI

ROWCOUNT_BIG

ERROR_LINE

SESSION_CONTEXT

ERROR_MESSAGE

SESSION_ID

ERROR_NUMBER

XACT_STATE

Konten terkait

• Apa fungsi database SQL?