大家帮我看个SQL2008字符串转换时间问题。执行提示从字符串转换日期和/或时间时，转换失败

[a312991915]

ALTER proc [dbo].[Sp_tj_Sjtj]
(
@Communityid varchar(10),
@type varchar(5) ,
@Stime datetime, --开始时间
@Etime datetime --截止时间
)
as

begin
declare @strsql varchar(8000),
@name varchar(20),
@where varchar(50)
if @Communityid='0' or @Communityid='' or @Communityid =null or @Communityid is null
set @Communityid ='null'
IF @Stime = ''
SET @Stime = NULL
IF @Etime = ''
SET @Etime = NULL
if(@type='1')
begin
set @name='TypeName'
set @where='t.Typeid';
end
else if(@type='2')
begin
set @name='FlowCategoryName'
set @where='fc.FlowCategoryid';
end
else
begin
set @name='FlowName'
set @where='f.Flowid';
end


set @strsql ='

select isnull( '+@name+',''未知'') name ,COUNT(cid) as ''合计'','+@where+' id from tblCase c
left join tblFlow f on c.Flowid=f.Flowid
left join tblFlowCategory fc on f.FlowCategoryid =fc.FlowCategoryid
left join tblType t on fc.typeid=t.Typeid where
(CommunityID='+@Communityid+' or '+@Communityid+' is null)
and (CONVERT(varchar(100),c.HappenTime,23)>='+@Stime+' or '+@Stime+' is null)
and (CONVERT(varchar(100),c.HappenTime,23)<='+@Etime+' or '+@Etime+' is null)
group by '+@where+','+@name+'

order by ''合计'' desc'
exec(@strsql)

end

[a312991915]

没答案，还是谢谢了。

[cpp2017]

CONVERT(varchar(100),c.HappenTime,23)>='+@Stime+' or '+@Stime+' is null

＝=>



IsNull(@Stime,getdate())> c.HappenTime

[a312991915]

不行啊。

[IHandler]

检查数据库中的数据行中列c.HappenTime的值是否有null 或 空字符串值

以及 参数 @Stime、@Etime 是否传了正确格式的值

[a312991915]

[Quote=引用 3 楼 ihandler 的回复:]
检查数据库中的数据行中列c.HappenTime的值是否有null 或 空字符串值

以及 参数 @Stime、@Etime 是否传了正确格式的值
[/Quote]
没有空的啊，我就算不拼语句。这样写都没事

select * from tblCase c
left join tblFlow f on c.Flowid=f.Flowid
left join tblFlowCategory fc on f.FlowCategoryid =fc.FlowCategoryid
left join tblType t on fc.typeid=t.Typeid
where (CommunityID=1 or Communityid is null)
and (CONVERT(varchar(100),c.HappenTime,23)>='2011-03-01')
and (CONVERT(varchar(100),c.HappenTime,23)<='2011-03-05')