VistaDB 6
VistaDB / Developer's Guide / SQL Reference / Control of Flow Statements / DECLARE
In This Topic
    DECLARE
    In This Topic

    Variables are allocated for the lifetime of this execution context and may be assigned values with the SET or SELECT statements.


    DECLARE @local_variable [AS] data_type

    DECLARE @myint bigint;

    Remarks

    DECLARE TABLE syntax from SQL Server is not currently supported.

    Example

    DECLARE @myval decimal( 5,2 );
    SET @myval = 155.55;
    

    See Also