plc check below query...

declare @a int=0

declare @t table(id int)

insert into @t(id) values(1),(2),(3)

select @a=ID from @t

select @a first

/******************STMT*******************/

set @a=0

select @a=@a+ID from @t

select @a second