h1

Toate functiile de configurare (functii sistem de configurare)

March 5, 2010

1) Functia sistem @@CONNECTIONS

Raport detaliat cu conexiunile efectuate la server procedura stocata sistem sp_monitor:

–2) Functia sistem @@DATEFIRST (T-SQL)

–specifica prima zi a saptamanii functia DATEFIRST

numerotarea incepe cu 1 de la ziua de luni si se termina la ziua de duminica cu 7

Exemplul2:

Practic in ex2 (m-am conectat vineri 1 singura data -coloana today din acest motiv are valoarea 1; coloana1 =5 pt.ca este ziua de vineri).

3) Functia sistem @@DBTS (T-SQL)

— exec nume_procedura_stocata_sistem (exec nume_procedura_stocata)

EXEC sp_help — intoarce toate tabelele, view-urile create etc.

4) Functia sistem @@LANGUAGE (T-SQL) si @@LANGID (T-SQL)

5) Functia sistem @@LOCK_TIMEOUT (T-SQL)

6) Functia sistem @@MAX_CONNECTIONS (T-SQL)

7) Functia sistem @@MAX_PRECISION (T-SQL)

8 ) Functia sistem @@OPTIONS (T-SQL)

9) Functia sistem @@NESTLEVEL (T-SQL)
Exemplul1:

Exemplul2: (@@NESTLEVEL)

Detalii despre folosirea prefixului N’ aici: (pt.string-uri unicode):

http://databases.aspfaq.com/general/why-do-some-sql-strings-have-an-n-prefix.html

10) Functia sistem @@REMSERVER (T-SQL)

11) Functia sistem @@SPID (T-SQL)

12) Functia sistem @@SERVERNAME (T-SQL)


13) Functia sistem @@SERVICENAME (T-SQL)

14) Functia sistem @@VERSION (T-SQL)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: