日期:2014-05-17 浏览次数:20570 次
declare @shuliang nvarchar (50)
SELECT sum (convert (int, [yingtuishu] )) FROM [Faliaominxi]where [liaohao]=@liaohao and [mark]='0' and [faliaodan]<>@faliaodan
DECLARE @shuliang NVARCHAR(50)
SELECT @shuliang = SUM(CONVERT (INT, [yingtuishu]))
FROM [Faliaominxi]
WHERE [liaohao] = @liaohao
AND [mark] = '0'
AND [faliaodan] <> @faliaodan