how to use declare in sql query code example

Example: declare value in sql

DECLARE  { @LOCAL_VARIABLE[AS] data_type  [ = value ] }