select * from tEmployee where CONVERT(varchar(5),生日字段,10)=CONVERT(varchar(5),getdate(),10)
转载于:https://www.cnblogs.com/star5/archive/2010/11/19/1881931.html
select * from tEmployee where CONVERT(varchar(5),生日字段,10)=CONVERT(varchar(5),getdate(),10)
转载于:https://www.cnblogs.com/star5/archive/2010/11/19/1881931.html