h1

Cap.20 Proceduri stocate ,functii utlizator

March 28, 2010

1) Sintaxa generala proceduri stocate  (ex.proc.stocata si executie proc stocata)

2)  Cum se definesc variabile intr-o procedura stocata

3) Folosire proceduri stocate pt.a intoarce valori

4) Intoarcerea unei valori dintr-o functie  stocata folosind cuv.cheie RETURN:

5) Lucrul cu cursori in procedurile stocate

6) Declararea variabilelor intr-o procedura stocata si asignarea valorilor pt.aceste valori declarate (clauzele declare si set):

7) Crearea unei functii utilizator (CREATE FUNCTION-crearea functiilor scalare in mssql)

Explicatia parametrilor:

Exemple CREATE FUNCTION:

Ex1:

Ex2:

Ex3:

8) Stergerea unei proceduri stocate sau functii utilizator (functii scalare)

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: