求动态SQL增加合计数的语句

[bigmingming]

A表中的s_sqlWhere条件是参数传入的。
SET @S_SQL = 'SELECT * FROM A'

IF @s_sqlWhere = ''
BEGIN
SET @S_SQL = @S_SQL + ' WHERE 1=2'
END
ELSE
BEGIN
SET @S_SQL = @S_SQL + ' WHERE 1=1 AND ' + @s_sqlWhere
END
我想把A表中字段PRICE合计数做为字段加在A表的返回数据集中。

[Tiger_Zhao]

加一行只能按#1的做法，加一列这样改

SET @S_SQL = 'SELECT *,SUM(PRICE) OVER() TOTAL FROM A'

[道玄希言]

declare @S_SQL nvarchar(max)
declare @S_SQL2 nvarchar(max)
declare @s_sqlWhere nvarchar(max)
set @s_sqlWhere = 'C1=''C'''

SET @S_SQL = 'SELECT  c1, c2, c3, c4, PRICE  FROM A'

SET @S_SQL2 = 'SELECT  '' '', '' '', '' '', '' '', sum(PRICE) as PRICE  FROM A'

IF @s_sqlWhere = ''
BEGIN
SET @S_SQL = @S_SQL + ' WHERE 1=2' 
SET @S_SQL2 = @S_SQL2 + ' WHERE 1=2' 
END
ELSE
BEGIN
SET @S_SQL = @S_SQL + ' WHERE 1=1 AND ' + @s_sqlWhere
SET @S_SQL2 = @S_SQL2 + ' WHERE 1=1 AND ' + @s_sqlWhere
END

SET @S_SQL = @S_SQL + ' union all ' + @S_SQL2 

exec(@S_SQL)

[bigmingming]

A表字段比较多，这样group by 后要加好多字段名，有没有更好的办法