27,579
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE TA
(
COL1 INT IDENTITY(1, 1),
COL2 VARCHAR,
COL3 DATETIME,
STATUS AS ( CASE
WHEN Datediff(D, COL3, Getdate()) > 3 THEN 1
ELSE 0
END )
)
GO
INSERT INTO TA VALUES('A', '2015-8-21')
INSERT INTO TA VALUES('B', '2015-8-12')
INSERT INTO TA VALUES('C', '2015-8-19')
INSERT INTO TA VALUES('D', '2015-8-20')
INSERT INTO TA VALUES('E', '2015-8-22')
GO
SELECT *
FROM TA
2015-8-23执行结果:
COL1 COL2 COL3 STATUS
1 A 2015-08-21 00:00:00.000 0
2 B 2015-08-12 00:00:00.000 1
3 C 2015-08-19 00:00:00.000 1
4 D 2015-08-20 00:00:00.000 0
5 E 2015-08-22 00:00:00.000 0