Home > Archive > SQL Anywhere database > June 2005 > what means @









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author what means @
Eric Verhorstert

2005-06-27, 3:23 am

ASA 9

I was wondering what the @ means in procedures:

CREATE procedure ml_begin_synchroniza
tion(IN @ml_usename VARCHAR(128))
BEGIN
......
END

Thanks
Eric
Breck Carter [TeamSybase]

2005-06-27, 9:23 am

No *real* significance in Watcom SQL, it is just another alphabetic
letter. From the book...

<identifier> ::= <alphabetic> { ( <alphabetic> | <numeric> ) }
| reserved word in double-quotes or square-brackets
| any string in double-quotes or square-brackets

<alphabetic> ::= letter, underscore (_), at sign (@), dollar sign ($)
or number sign (#)

<numeric> ::= digit 0 to 9

It is a holdover from Transact SQL where it is significant, and some
folks (like me) use it for all local variables and parameters so there
is no confusion with column names.

Breck



On 26 Jun 2005 23:29:50 -0700, Eric Verhorstert <ontsnapt@hotmail.com>
wrote:

>ASA 9
>
>I was wondering what the @ means in procedures:
>
>CREATE procedure ml_begin_synchroniza
tion(IN @ml_usename VARCHAR(128))
>BEGIN
>.....
>END
>
>Thanks
>Eric


--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com