我该如何执行检查 [英] how can i perform check on it

问题描述

SELECT DATEDIFF (DAY, @ID1ExpDate, GETDATE() + 1) AS DayDiff

我需要检查如果此Qurey的结果小于90，然后执行某些操作.

I need to check that if result of this qurey is less then 90 then perform some thing. How can I perform check on it?

推荐答案

您可以使用CASE语句.

You can use CASE Statement.

SELECT CASE <variable> WHEN <value>      THEN <returnvalue>
                       WHEN <othervalue> THEN <returnthis>
                                         ELSE <returndefaultcase>
       END
FROM <table>

此处 [

Here[^] is Case Statement documentation.

这篇关于我该如何执行检查的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！