A local variable is defined using TSQL by using statement “DECLARE” and the name of the local variable should begin with “@” sign as the first character of its name.
For example, integer CNT we will define local variable as, DECLARE @CNT INT
