22,209
社区成员
发帖
与我相关
我的任务
分享
DATEDIFF(YEAR,CASE BeginDate WHEN '' THEN GETDATE(),GETDATE()) + 1 AS DiffDate
DATEDIFF(YEAR,(CASE BeginDate WHEN '' THEN GETDATE() else BeginDate end),getdate()) + 1 AS DiffDate
''''''
DATEDIFF(YEAR,(CASE BeginDate WHEN '' THEN GETDATE() else BeginDate end),getdate()) + 1 AS DiffDate
''''--就是双引号字符