代码搜索：datediff
找到约 324 项符合「datediff」的源代码
代码结果 324
www.eeworm.com/read/438626/7729091
sql 视图的建立.sql
alter VIEW STU_INFO(学生名,成绩,年龄,电话,电子邮件,班级,学院)
AS
SELECT STU_NAME,ISNULL(CAST(STU_SCORE AS CHAR(10)),'成绩未录入'),
ISNULL(CAST(DATEDIFF(YY,STU_BIRTHDAY, GETDATE()) AS CHAR(20)),'暂无') AS STU_AGE,
www.eeworm.com/read/174902/9569899
sql 组合查询条件的存储过程.sql
/*
功能：查询每块水表的最后一次抄表时间，距指定时间超过指定值的记录
*/
-- declare @current_date datetime
-- set @current_date = getdate()
--
-- select *
-- from v_last_read_rec r
-- where datediff(day, r.read_time,@curre
www.eeworm.com/read/107485/15606208
sql cursordemo5.sql
/* 文件名称: CursorDemo5.sql */
SET NOCOUNT ON
GO
-- 使用 Transact-SQL 扩充语法声明一个启用效能最优化的只读数据指针
DECLARE foxman_cursor CURSOR
LOCAL
FAST_FORWARD
FOR SELECT 姓名,年龄 = DateDiff(yy,出生日期,GETD