50分求援:如何连接数据库中多个字段的值并与日期进行比较? select * from Awhere datediff(day,getdate(),cast(ystr+'-'+mstr+'-'+dstr as datetime))=0 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from Awhere datediff(day,getdate(),cast(cast(ystr as varchar(4))+'-'+cast(mstr as varchar(2))+'-'+cast(dstr as varchar(2)) as datetime))=0 select * from Awhere datediff(day,getdate(),cast(ystr as varchar)+'-'+cast(mstr as varchar)+'-'+cast(dstr as varchar))=0 请问自动编号问题? 请问我新装的sql2005,存储过程右键没有"执行存储过程"是为什么? [有图说明] 批量插入2个问题 同一台server里面有两个数据库更新 #################求一sql过滤语句或存储过程? 6核服务器运行Sqlserver2005不稳定,周期性死机 健列信息不足或不正确,更新影响过多的列 批量插入数据? 学习SQL编程,哪本书比较好?(中文版) 收费系统 关于截字符的串的问题?在线等!急! 邹建在吗?如何用SQL实现这个功能。
from A
where datediff(day,getdate(),cast(cast(ystr as varchar(4))+'-'+cast(mstr as varchar(2))+'-'+cast(dstr as varchar(2)) as datetime))=0
from A
where datediff(day,getdate(),cast(ystr as varchar)+'-'+cast(mstr as varchar)+'-'+cast(dstr as varchar))=0