Jesse wrote:
> I have skimmed through several pages of instructions on creating
> stored procedures, and I can't seem to find when I should and should
> not use the "@" symbol before a variable name? I have seen a lot of
> procedures where it's always used, and I've written a procedure or two
> that doesn't use it at all, and it seems to work fine. What's the
> difference?
@ as a name prefix signifies a user variable, NOT a stored routine
parameter, and NOT a variable declared in a stored procedure. It might
appear to work fine when there are user variables with the same names as
declared variables, but undrer such circumstances it will not be working
fine at all.
PB
-----
>
> Thanks,
> Jesse
>
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.9.5/377 - Release Date: 6/27/2006
