set @strSql4='SELECT sum(car_kilometre2-car_kilometre) FROM lw_carodd where car_id!=''''' if @sql1 is null or @sql1=''set @strSql4 = @strSql4 + ''elsebeginset @strSql4= @strSql4+ ' ' + 'and usedate='''+cast(@sql1 as NVarChar)+''''end
----------------------------------------------------
在查询分析器里运行: SELECT COUNT(*) AS Expr1FROM lw_caroddWHERE (car_id <> '') AND (car_usedate = '2006-09-21') 这个如果未有条件符合那么得到的结果是0 SELECT SUM(car_kilometre2 - car_kilometre) AS Expr1FROM lw_caroddWHERE (car_id <> '') AND (car_usedate = '2006-09-21') 而这个如果未有条件符合那么得到的是没有任何显示,怎么办? 因为写在存储里会出现错误:例外詳細資訊: System.FormatException: 輸入字串格式不正確。行 716:Int32 Tcount=Int32.Parse(cmd.ExecuteScalar().ToString());----------------------------------set @strSql4='select case sum(car_kilometre2-car_kilometre) when ’’ then '+''''+'NO DATE'+''''+' when !=’’ then sum(car_kilometre2-car_kilometre) end as ddd from lw_carodd where car_id!=''''' 难道要这样判断,可我这句有语法错误
----------------------------------------------------
在查询分析器里运行: SELECT COUNT(*) AS Expr1FROM lw_caroddWHERE (car_id <> '') AND (car_usedate = '2006-09-21') 这个如果未有条件符合那么得到的结果是0 SELECT SUM(car_kilometre2 - car_kilometre) AS Expr1FROM lw_caroddWHERE (car_id <> '') AND (car_usedate = '2006-09-21') 而这个如果未有条件符合那么得到的是没有任何显示,怎么办? 因为写在存储里会出现错误:例外詳細資訊: System.FormatException: 輸入字串格式不正確。行 716:Int32 Tcount=Int32.Parse(cmd.ExecuteScalar().ToString());----------------------------------set @strSql4='select case sum(car_kilometre2-car_kilometre) when ’’ then '+''''+'NO DATE'+''''+' when !=’’ then sum(car_kilometre2-car_kilometre) end as ddd from lw_carodd where car_id!=''''' 难道要这样判断,可我这句有语法错误
解决方案 »
- AJAXToolkit ?
- 求详解
- asp.net reporting services数据集窗口没了(SOS)(在线等)
- 页面锁定
- DataLsit中拖放用户控件,然后进行分页....点下一页,无法显示数据.......
- 关于window.open打开新窗口的问题
- OleDb操作excel的问题:怎么用oledb删除excel中的数据,急啊!
- 怎样实现Radiobuttionlist的不选!!请各位大虾帮忙
- 数字软键盘制作?
- 高分请教
- 帮帮我,怎么在网页里做到类似资源管理器的浏览
- 谁有能读出直接foxpro6.0以上数据库的办法 ,我用Microsoft.Jet.OLEDB.4.0只能读到fp5.0
{
Tcount=0;
}
else
{
Tcount=Int32.Parse(cmd.ExecuteScalar().ToString());
}