At 01:08 PM 9/04/2003 +0200, you wrote:

>Ronaldo,
>
>r> What's the inicial value of a variable?
>r> I can do this whitout make "SOMA = 0" in the inicial part of code?
>r> "SOMA = SOMA + POWER((NOTA_PROVA - MEDIA),2);"
>
>if I was you I would avoid any chance of discovering it the hard way,
>i. e. I always initialize everything.

Variables are not automatically initialized: they are NULL until they
receive a value.

>AFAIK variables in stored procedures are not initialized; I seem to
>recall even that they keep the value from previous calls to the
>stored procedure, but I'm not sure.

No, the scope of variables is entirely local to a single invocation.

heLen