h1

Functii metadata

March 5, 2010

Tutorial : Functii MetaData

1) Functia COL_LENGTH (T-SQL) -lungimea unei coloane

2) Functia COL_NAME (T-SQL) — numele unei coloane

3) Functia COLUMNPROPERTY (T-SQL)

Tabelele cu lista proprietatilor si valorile posibile intoarse:

Exemplu ce foloseste functia  COLUMNPROPERTY:

4) Functia DATABASEPROPERTY (T-SQL)

Tabelul cu numele proprietatilor:

Exemplu DATABASEPROPERTY:

5) Functia DB_ID (T-SQL)

6) Functia DB_NAME (T-SQL)

7) Functia FILE_ID (T-SQL)

8)Functia FILE_NAME (T-SQL)

9)FILEGROUP_ID (T-SQL)

10) Functia FILEGROUP_NAME (T-SQL)

11) Functia FILEGROUPPROPERTY (T-SQL)

Tabelul cu numele proprietatilor:

12) Functia FILEPROPERTY (T-SQL)

Tabelul cu numele proprietatilor:

13) Functia FULLTEXTCATALOGPROPERTY (T-SQL)
— intoarce informatii despre proprietatiile fulltext din cataloage

Tutorial:

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

Vezi si:

CREATE FULLTEXT INDEX (Transact-SQL):

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

ALTER FULLTEXT INDEX (Transact-SQL):

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

CREATE FULLTEXT CATALOG (Transact-SQL) :

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

Totul despre fulltext si proceduri stocate fulltext aici:

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

14) Functia FULLTEXTSERVICEPROPERTY (T-SQL)

–intoarce informatii despre proprietatiile fulltext service level pt cataloage service-level properties.

Tutorial:

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

15) Functia INDEX_COL (T-SQL)

16) Functia INDEXPROPERTY (T-SQL)

17) Functia OBJECT_ID (T-SQL)

18) Functia OBJECT_NAME (T-SQL)

19) Functia OBJECTPROPERTY (T-SQL)


— intoarce informatii despre obiectele curente din bd

Tabelul cu numele proprietatilor functiei OBJECTPROPERTY:

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

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

21) Functia TYPEPROPERTY (T-SQL)
–Returns information about a data type.

— Informatii SET NO COUNT ON/OFF

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

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: