数据库日期比较
数据库有一个“日期”字段,现在我想用当前的年份去跟数据库的年份去比较是不是存在,代码应该如何写?select year(日期) FROM table 查到的数据有2008,2009,2010
string yr = DateTime.Now.Year.ToString();
--------------------编程问答-------------------- "select 日期 from table where year(日期)="+DateTime.Now.Year
--------------------编程问答-------------------- "select top 1 日期 from table where year(日期)="+DateTime.Now.Year
如果返回的数据行数大于0则说明存在 --------------------编程问答-------------------- select year(日期) FROM table 查到的数据有2008,2009,2010
string yr = DateTime.Now.Year.ToString();
那就接着写
" select count(1) from table where year(日期)="+yr;
--------------------编程问答-------------------- "select count(*) from table where year(日期)="+DateTime.Now.Year
--------------------编程问答-------------------- string sql="select count(*) from table where year(日期)='"+DateTime.Now.Year+"'"
或select count(*) from table where datediff(y,日期,getdate())=0
补充:.NET技术 , ASP.NET