90天后自动更改列 [英] Automatic value change from column after 90 days

问题描述

听到我的代码想要知道IsActive ='Y'将如何自动90天后

Hear is my code want to know how will IsActive ='Y' Automatic After 90 Days

SELECT * FROM FacultyRelievingDetails
WHERE ApplyDate >= DATEADD(DAY, -90, ApplyDate) And FacultyId='LCVD-2003396' AND CollegeId=387 AND IsRelieved='Y'

请帮帮我



我的尝试：



听到我的代码想知道IsActive ='Y'90天后自动怎么样





SELECT * FROM FacultyRelievingDetails

WHERE ApplyDate> = DATEADD（DAY，-90，ApplyDate）和FacultyId = LCVD-2003396'和CollegeId = 387 AND IsRelieved ='Y'





请帮帮我

please Help Me

What I have tried:

Hear is my code want to know how will IsActive ='Y' Automatic After 90 Days


SELECT * FROM FacultyRelievingDetails
WHERE ApplyDate >= DATEADD(DAY, -90, ApplyDate) And FacultyId='LCVD-2003396' AND CollegeId=387 AND IsRelieved='Y'


please Help Me

推荐答案

您需要的只是创建计算列。请参阅：在表中指定计算列 [ ^ ]

All what you need is to create computed column. See: Specify Computed Columns in a Table[^]

这篇关于90天后自动更改列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！