Declaring Datatypes for Local Variable in a Batch or Procedure

Use the declare function to declare the datatype for a local variable in a batch or stored procedure.

declare @variable_name datatype 
		[, @variable_name datatype ]...

Example 1

For example:
declare @hope money
Parent topic: Datatypes of Columns, Variables, or Parameters