27,579
社区成员
发帖
与我相关
我的任务
分享
group by 跑哪去了?
exec ( 'select sum(JiHua_Count) from JiHua_Msg where'''+@SqlWhere+'''')
exec ( 'select sum(JiHua_Count) from JiHua_Msg where''+@SqlWhere+''')
exec ( 'select sum(JiHua_Count) from JiHua_Msg where '+@SqlWhere)
string sqlWhere="IsDelete=0 and ( JiHua_Time between ''2009-11-02'' and ''2009-11-03'')"
SET @SqlWhere=REPLACE(@SqlWhere,'''','''''')
string sqlWhere = SeletParam(model).Replace("'","''");
internal string GetStatSumCount(JiHuaInfo model)
{
string sqlWhere = SeletParam(model);
SqlParameter[] parameters = {
new SqlParameter("@SqlWhere",SqlDbType.VarChar,50)
};
parameters[0].Value = sqlWhere;
return RunScalar("Proc_JiHua_StatSumCount", parameters).ToString();
}
private string SeletParam(JiHuaInfo model)
{
string sql = " IsDelete=0 ";//判断是否为删除数据
if (!string.IsNullOrEmpty(model.JiHua_Time1) && !string.IsNullOrEmpty(model.JiHua_Time2))
{
sql += " and ( JiHua_Time between ''" + model.JiHua_Time1 + "'' and ''" + model.JiHua_Time2 + "'') ";
}
CREATE PROCEDURE Proc_JiHua_StatSumCount
@SqlWhere varchar(500)
AS
execute ( 'select sum(JiHua_Count) from JiHua_Msg where '+ @SqlWhere)
GO
DECLARE @SqlWhere NVARCHAR(400)
SET @SqlWhere='IsDelete=0 and ( JiHua_Time between ''2009-11-02'' and ''2009-11-03'')'
PRINT ( 'select sum(JiHua_Count) from JiHua_Msg where '+ @SqlWhere)
select sum(JiHua_Count) from JiHua_Msg where IsDelete=0 and ( JiHua_Time between '2009-11-02' and '2009-11-03')
DECLARE @SqlWhere NVARCHAR(400)
SET @SqlWhere='IsDelete=0 and ( JiHua_Time between ''2009-11-02'' and ''2009-11-03'')'
PRINT ( 'select sum(JiHua_Count) from JiHua_Msg where '+ @SqlWhere)
select sum(JiHua_Count) from JiHua_Msg whereIsDelete=0 and ( JiHua_Time between '2009-11-02' and '2009-11-03')
将
IsDelete=0 and ( JiHua_Time between '2009-11-02' and '2009-11-03' )
替换为:
IsDelete=0 and ( JiHua_Time between ''2009-11-02'' and ''2009-11-03'' )
print 'select sum(JiHua_Count) from JiHua_Msg where'+ @SqlWhere