h1

Cap.10 Lucrul cu functii, parametri si tipuri de date (variabile)

March 19, 2010

1)  Variabile

2) Parametri sunt pt.stocarea valorilor si folositi in procedurile stocate:

3) Referinte ale coloanelor:

4) SUBSTRING si UPPER:

5) Clauza DISTINCT:

6) LOWER:

7)

8)

9) Operatorii UNION, INTERSECT si EXCEPT:

10) Operatorul except exemple:

11) Functiile POSITION si CHARINDEX pt.siruri de caractere:

12) Functiile CHAR_LENGTH(LEN) si OCTET_LENGTH:

13) BIT_LENGTH si  EXTRACT:

14) Functiile CURRENT_TIME si CURRENT_DATE:

15) Functia CURRENT_TIMESTAMP si fctii data si timp:

16) Functia CAST si CASE exemplu:

17) Clauza SELECT ex.complet:

18) Subquery si case

19) Functia NULLIF:


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: