SQL 存储过程怎么赋值

SQL 存储过程如何赋值
Fraction --每个人语文分数字段int 形

SQL code

declare @num int --总数set @num= select sum(Fraction) from Student where names='小红'

SQL code

declare @num int --总数select @num= sum(Fraction) from Student where names='小红'
[解决办法]
SQL code
declare @num int --总数set @num= (select sum(Fraction) from Student where names='小红')