摘要：
1.根据生日来查年龄declare @nl datetime, @str varchar(4000)set @str=''select top 50 @str =@str++','+ name+':'+convert(nvarchar,DATEDIFF(yy,birthday,getdate())) from BasicData..user_baseinfo where datediff(dd,birthday,getdate()) <>0select Substring(@str,2,LEN(@str))2.查询某个时间select 阅读全文
