SQL作业中我这段代码有何错误? delete from users where datediff("n",utime,getdate())<=1delete from permissions where datediff("n",utime,getdate())<=1 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 踏网无痕,怎么提示“为datediff指定了无效的参数1”?我只分析一条delete from users where datediff("n",utime,getdate())<=1。 delete from users where datediff("n",utime,getdate())<=1delete from permissions where datediff("n",utime,getdate())<=1 有呀!utime字段是datetime类型。 你的users和permissions表中都有utime的字段么?看样子是没有,如果都有的话那么就不应该有错误!因为两个操作只是表的不同而已呀! 成功!只能用minute,不能用"n" delete from users where datediff(n,utime,getdate())<=1delete from permissions where datediff(n,utime,getdate())<=1 一个简单E-R图画法 SQL2000哪些语句操作更会占用内存? 难题,超难呀! 看看本区的精华帖? 查询得到的结果向上求比 在线急等,大分相送,有关sql 6.0 如何查看SQL Server 2000 的操作日志 ?在线等 弱水兄请进:analyze所有表后,为什么有的为0,有的为null? Sql Server 数据库问题?? sql 急!经典学生老师问题 请教in函数中字符串的处理方法,谢谢!
delete from permissions where datediff("n",utime,getdate())<=1
delete from permissions where datediff(n,utime,getdate())<=1