首页新闻找找看学习计划

条件怎么加 ???

0
[已关闭问题] 关闭于 2015-10-10 10:04
 sbSql.Append(@"EXEC('select ID,PumpingName,(select Max(cnt) from
( 
select count(PumpModel) as cnt  from FMDS_Water_IrrigaDrainageStat
union all
select count(PumpManu) as cnt from FMDS_Water_IrrigaDrainageStat
union all
select count(PumpUnits) as cnt from FMDS_Water_IrrigaDrainageStat
union all
select count(PumpTime) as cnt from FMDS_Water_IrrigaDrainageStat
union all
select count(PumpPower) as cnt from FMDS_Water_IrrigaDrainageStat
    
) t
                      
from [FMDS_Water_IrrigaDrainageStat] '+ @Condition +' '+@SortBy)");

如上,每个count语句需要加上@Condition ,的怎么写

lctk的主页 lctk | 初学一级 | 园豆:69
提问于:2015-09-25 12:30
< >
分享
所有回答(1)
0

原样输出

lctk | 园豆:69 (初学一级) | 2015-10-10 10:04
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册