h1

Functii de securitate si functii sistem (functii de sistem @@nume_fctie)

March 5, 2010

Lista completa a functiilor de securitate mssql

A) Functiile de securitate mssql

1) IS_MEMBER (T-SQL)


2) IS_SRVROLEMEMBER (T-SQL)

3) SUSER_SID (T-SQL)


4) SUSER_ID,SUSER_NAME (T-SQL),SUSER_SNAME (T-SQL)

5) Functiile USER_ID (T-SQL)

6) Functia USER (T-SQL)


7) Functia USER_NAME (T-SQL)

B)  Functiile sistem mssql

1) Functia APP_NAME (T-SQL)


2) Functia CURRENT_USER (T-SQL)

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

Exemplul1:

Exemplul2:

Exemplul5:

Exemplul6:

6) Functia FORMATMESSAGE (T-SQL)

7) Functia GETANSINULL (T-SQL)

8 ) Functia  HOST_ID (T-SQL)

9) Functia HOST_NAME (T-SQL)

10) Functia IDENT_INCR (T-SQL)


11) Functia IDENT_CURRENT (T-SQL)

12) Functia IDENT_SEED (T-SQL)

13) Functia sistem @@IDENTITY (T-SQL) si IDENTITY (Function) (T-SQL)


@@IDENTITY:

Obs. Proprietatea IDENTITY e folosita in clauzele CREATE TABLE si ALTER TABLE

14) Functia ISNULL (T-SQL)


15) Functia ISNUMERIC (T-SQL)

16) Functia NEWID (T-SQL)

Exemplul2:


17) NULLIF (T-SQL)

Exemplul2:

18) Functia PARSENAME (T-SQL)


Detalii functia PARSENAME aici:

http://msdn.microsoft.com/en-us/library/ms188006.aspx

19) Functia PERMISSIONS (T-SQL)

Exemplul2:

Exemplul3:

20) Functia sistem @@ROWCOUNT (T-SQL)

21) Functia SESSION_USER (T-SQL)

Exemplul2:

Exemplul3:

22) Functia STATS_DATE (T-SQL)

23) SYSTEM_USER (T-SQL)

Exemplul2:

Exemplul3:

24) Functia sistem @@TRANCOUNT (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: