下列代码转换成SQL Server 2005应该怎么写？string sql = string.Format(@"SELECT DISTINCT COUNT(*), SUM(YESNO) ""是票数"", COUNT(*) - SUM(YESNO) ""否票数"", COUNT(DISTINCT CPNURSE) ""参加人数"",CONTENT ""指标"", SUM(YESNO) / COUNT(*) ""肯定率"" FROM KSYW_HSZGZMYCP WHERE TO_CHAR(CPDATE,'yyyyMM')>='{0}' AND TO_CHAR(CPDATE,'yyyyMM')<'{1}' GROUP BY CONTENT",dtBegin.DateTime.ToString("yyyyMM"),dtEnd.DateTime.ToString("yyyyMM"))
下列代码转换成SQL Server 2005应该怎么写？string sql = string.Format(@"SELECT DISTINCT COUNT(*), SUM(YESNO) ""是票数"", COUNT(*) - SUM(YESNO) ""否票数"", COUNT(DISTINCT CPNURSE) ""参加人数"",CONTENT ""指标"", SUM(YESNO) / COUNT(*) ""肯定率"" FROM KSYW_HSZGZMYCP WHERE TO_CHAR(CPDATE,'yyyyMM')>='{0}' AND TO_CHAR(CPDATE,'yyyyMM')<'{1}' GROUP BY CONTENT",dtBegin.DateTime.ToString("yyyyMM"),dtEnd.DateTime.ToString("yyyyMM"))
--語法只有這一點不一樣,改下就可以了
convert(varchar(6),CPDATE,112)>='{0}' AND convert(varchar(6),CPDATE,112)<'{1}'