VistaDB 5
DECLARE

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