CREATE PROCEDURE sp_selVisitStat @strDate char(20) as DECLARE @SQL varchar(800)
SET @SQL='select visitStat=sum(visit) from db_Enumerate
Where convert(varchar(20),etime,121) like ''%'+rtrim(@strDate)+'%'''
exec(@SQL)
GO
SET @SQL='select visitStat=sum(visit) from db_Enumerate
Where convert(varchar(20),etime,121) like ''%'+rtrim(@strDate)+'%'''
exec(@SQL)
GO
as DECLARE @SQL varchar(800)
SET @SQL='select visitStat=sum(visit) from db_Enumerate
Where convert(varchar(10),etime,121) like ''%'+@strDate+'%''' --改了
exec(@SQL)
GO
2005 or
2005-05 or
2005-05-05
Where convert(varchar(20),etime,121) ''%'+@strDate+'%'''
exec(@SQL)
Where convert(varchar(20),etime,121) like ''%'+@strDate+'%'''
exec(@SQL)