我这个SQL语句，运行没有结果的？

[rocket204]

create table T (v int)
insert into T
select 1
union all select 2
union all select 3
union all select 4

select * from T

declare @a int
declare @b int
select @a=10
select @b=0
select @a=@a+v,@b=@b+v from T

看看该怎么改，谢谢

[pt1314917]

declare @a int 
declare @b int 
select @a=10 
select @b=0 
select @a=@a+v,@b=@b+v from T 
select @a,@b

[pt1314917]

--简化点，直接：
select a=10+sum(v),b=sum(v) from t

[CosmoKey]

declare @a int
declare @b int
select @a=10
select @b=0
select @a=@a+v,@b=@b+v from T
select @a,@b


正解
select @a=@a+v,@b=@b+v from T 只是赋值
却没有输出

[Bruce_Qiu]

create table T (v int)
insert into T
select 1
union all select 2
union all select 3
union all select 4

select * from T

declare @a int
declare @b int
select @a=10
select @b=0
select va=@a+v,vb=@b+v from T

drop table T

[忆轩辕]

--最后加上

select @a,@b

[rocket204]

谢谢