ASP+SQLSER2000
ASP文件中有以下语句:
<%
year_=1998
sql="select name,(select sum(age) from ryxx where year(csdate)='&year_&' and name =a.name ) as age from ryxx a group by name "
%>
不能实现语句条件之一: year(csdate)=1998 ,但若把以上语句中的'year_'改为1998,查询的结果就对了,请问为什么?
ASP文件中有以下语句:
<%
year_=1998
sql="select name,(select sum(age) from ryxx where year(csdate)='&year_&' and name =a.name ) as age from ryxx a group by name "
%>
不能实现语句条件之一: year(csdate)=1998 ,但若把以上语句中的'year_'改为1998,查询的结果就对了,请问为什么?