试试
select id,yuhuzhuguanxi,xingming,xingbie,chushengriqi from huchengyuan where
hubianhao like '%%' and 1913 < convert(varchar(10),datepart(year,chushengriqi))
and convert(varchar(10),datepart(year,chushengriqi))< 1993
select id,yuhuzhuguanxi,xingming,xingbie,chushengriqi from huchengyuan where
hubianhao like '%%' and 1913 < convert(varchar(10),datepart(year,chushengriqi))
and convert(varchar(10),datepart(year,chushengriqi))< 1993
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货