这样写为什么不行呢

[wl58796351]

declare @gross float;
declare @tare float;
declare @net float;
declare @countt int;
declare @fahuoNo varchar(50);

SELECT
@fahuoNo= dbo.T_FahuoList.F_FahuoNo,
@countt= count(*) as counting,
@gross = sum(dbo.T_Standard.F_Gross) as sumgross,
@tare= sum(dbo.T_Standard.F_Tare) as sumtare,
@net =sum( dbo.T_Standard.F_Net) as sumnet
FROM dbo.T_FahuoList INNER JOIN dbo.T_Standard ON dbo.T_FahuoList.F_stdno = dbo.T_Standard.F_StdNo

where dbo.T_FahuoList.F_FahuoNo='201608120001'
group by dbo.T_FahuoList.F_FahuoNo

print @fahuoNo;

[wl58796351]

消息 156，级别 15，状态 1，第 11 行 关键字 'as' 附近有语法错误。

[中国风]

declare @gross float;
declare @tare float;
declare @net float;
declare @countt int;
declare @fahuoNo varchar(50);

SELECT  
@fahuoNo=  dbo.T_FahuoList.F_FahuoNo,
@countt= count(*) ,
@gross = sum(dbo.T_Standard.F_Gross) , 
@tare= sum(dbo.T_Standard.F_Tare) ,
@net =sum( dbo.T_Standard.F_Net) 
FROM  dbo.T_FahuoList INNER JOIN  dbo.T_Standard ON dbo.T_FahuoList.F_stdno = dbo.T_Standard.F_StdNo

where  dbo.T_FahuoList.F_FahuoNo='201608120001'
group by dbo.T_FahuoList.F_FahuoNo

print @fahuoNo;

[中国风]

把别名去掉，变量赋值时不能用别名

[wl58796351]

ok 是这个问题