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;
DECLARE @myval decimal( 5,2 ); SET @myval = 155.55;