Aracılığıyla paylaş


Sistem işlevleri (Transact-SQL)

Aşağıdaki işlevler üzerinde işlem gerçekleştirmek ve değerleri, nesneler ve ayarları hakkında bilgi döndürür. SQL Server.

The Transact-SQL sistem işlevleri and their determinism özellik are listed in the following tablo. Işlev determinism hakkında daha fazla bilgi için bkz: Deterministic ve Nondeterministic işlevler.

İşlev

Determinism

app_name

Nondeterministic

SERVİS TALEBİ ifade

Deterministic

CAST ve ÇEVIR

Deterministic ile kullanılan sürece DateTime, smalldatetime, or sql_variant.

BİRLEŞİM

Deterministic

collationproperty

Nondeterministic

columns_updated

Nondeterministic

current_timestamp

Nondeterministic

current_user

Nondeterministic

VERİUZUNLUĞU

Deterministic

@@ HATA

Nondeterministic

error_line

Nondeterministic

error_message

Nondeterministic

error_number

Nondeterministic

error_procedure

Nondeterministic

error_severity

Nondeterministic

ERROR_STATE (Transact-SQL)

Nondeterministic

fn_helpcollations

Deterministic

fn_servershareddrives

Nondeterministic

fn_virtualfilestats

Nondeterministic

formatmessage

Nondeterministic

getansinull

Nondeterministic

host_id

Nondeterministic

host_name

Nondeterministic

ident_current

Nondeterministic

ident_incr

Nondeterministic

ident_seed

Nondeterministic

@@ KİMLİĞİ

Nondeterministic

IDENTITY (işlev)

Nondeterministic

isdate

Nondeterministic

isnull

Deterministic

isnumeric

Deterministic

newid

Nondeterministic

nullif

Deterministic

parsename

Deterministic

original_login

Nondeterministic

@@ rowcount

Nondeterministic

rowcount_big

Nondeterministic

scope_identity

Nondeterministic

serverproperty

Nondeterministic

sessionproperty

Nondeterministic

session_user

Nondeterministic

stats_date

Nondeterministic

sys.dm_db_index_physical_stats (Transact-SQL)

Nondeterministic

system_user

Nondeterministic

@@ trancount

Nondeterministic

update()

Nondeterministic

KULLANICI_ADI

Nondeterministic

xact_state

Nondeterministic

See Also

Reference