select M_Name,M_ZhengJian,M_ZJCode
from G_Member
where M_ZhengJian = '身份证'
and substring(M_ZJCode,len(M_ZJCode)-6,4)=substring(convert(char(8),getdate(),112),5,4)未测试。
from G_Member
where M_ZhengJian = '身份证'
and substring(M_ZJCode,len(M_ZJCode)-6,4)=substring(convert(char(8),getdate(),112),5,4)未测试。
from G_Member
where M_ZhengJian ='身份证' and case Len(M_ZJCode)
when 15 then substring(M_ZJCode,9,4)
when 18 then substring(M_ZJCode,11,4)
else '' end=right(convert(varchar(8),getdate(),112),4)
写错了,想偷懒才发现18-6<>11。:(
select * from tablename where day(会员生日字段名)=day(getdate()) and month(会员生日字段名)=month(getdate())
--2.
select * from tablename where datepart(day,会员生日字段名)=datepart(day,getdate()) and datepart(month,会员生日字段名)=datepart(month,getdate())
--3.
select * from tablename where right(convert(varchar(10),会员生日字段名),8)=right(convert(varchar(10),getdate()),8)
select * from tablename where right(convert(varchar(10),会员生日字段名),5)=right(convert(varchar(10),getdate()),5)
我参考zjcxc(邹建)朋友的方法已经成功实现,在此感谢各位。