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

Işlevler (Transact-SQL)