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;