sql set and declare variable code example

Example: declare value in sql

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