2、 select add_date, point, description from tb1 where datepart(year,add_date)=edit1 and datepart(mm,add_date)=edit2
1.select * from tb1 where datediff(month,add_date,getdate()) = 0 2.select * from tb1 where datepart(year ,getdate())= @edit1 --参数是传进来的 and datepart(month,getdate()) =@edit2 --参数是传进来的
1.select * from tb1 where datediff(month,add_date,getdate()) = 0 2.select * from tb1 where datepart(year ,add_date)=@edit1 --参数是传进来的 and datepart(month,add_date)= =@edit2 --参数是传进来的---
select add_date, point, description from tb1 where datepart(year,add_date)=edit1
and datepart(mm,add_date)=edit2
2.select * from tb1
where datepart(year ,getdate())= @edit1 --参数是传进来的
and datepart(month,getdate()) =@edit2 --参数是传进来的
2.select * from tb1
where datepart(year ,add_date)=@edit1 --参数是传进来的
and datepart(month,add_date)= =@edit2 --参数是传进来的---