定义表格语句SQL Server

发布于 2025-02-10 22:37:41 字数 939 浏览 1 评论 0原文

我正在尝试使用案例语句设置变量，但我没有如何定义要运行此语句的表。

DECLARE @Status varchar(50);
SET @Status = CASE
        WHEN id_tag = 'B4A63CDF' AND expiry> CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 0 AND blocked = 0
              THEN  'Accepted'
        WHEN id_tag = 'B4A63CDF' AND expiry > CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 0 AND blocked = 1
               THEN 'Blocked'
        WHEN id_tag = 'B4A63CDF' AND expiry> CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 1 AND blocked = 0
               THEN 'ConcurrentTx'
        WHEN id_tag = 'B4A63CDF' AND expiry< CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 0 AND blocked = 0
               THEN 'Expired'
               ELSE 'Invalid'
END

这是桌子。 ID_TAG是唯一的。

原文

I'm trying to set the variable using a case statement but I don't how to define the table which I want to run this statement.

DECLARE @Status varchar(50);
SET @Status = CASE
        WHEN id_tag = 'B4A63CDF' AND expiry> CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 0 AND blocked = 0
              THEN  'Accepted'
        WHEN id_tag = 'B4A63CDF' AND expiry > CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 0 AND blocked = 1
               THEN 'Blocked'
        WHEN id_tag = 'B4A63CDF' AND expiry> CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 1 AND blocked = 0
               THEN 'ConcurrentTx'
        WHEN id_tag = 'B4A63CDF' AND expiry< CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 0 AND blocked = 0
               THEN 'Expired'
               ELSE 'Invalid'
END

Here's the table. id_tag is unique.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

Smile简单爱 2025-02-17 22:37:41

我认为，当中的表达式中的 select ...从中选择表达式时，我们可以尝试使用case，从中可能不需要使用变量来执行此操作。

t可以代替您的表格名称。

SELECT *,
    CASE
        WHEN id_tag = 'B4A63CDF' AND expiry> CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 0 AND blocked = 0
              THEN  'Accepted'
        WHEN id_tag = 'B4A63CDF' AND expiry > CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 0 AND blocked = 1
               THEN 'Blocked'
        WHEN id_tag = 'B4A63CDF' AND expiry> CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 1 AND blocked = 0
               THEN 'ConcurrentTx'
        WHEN id_tag = 'B4A63CDF' AND expiry< CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 0 AND blocked = 0
               THEN 'Expired'
               ELSE 'Invalid'
    END 
FROM T

I think we can try to use CASE WHEN expression in SELECT ... FROM that might not need to use a variable to do that.

T can be instead of your really table name.

SELECT *,
    CASE
        WHEN id_tag = 'B4A63CDF' AND expiry> CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 0 AND blocked = 0
              THEN  'Accepted'
        WHEN id_tag = 'B4A63CDF' AND expiry > CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 0 AND blocked = 1
               THEN 'Blocked'
        WHEN id_tag = 'B4A63CDF' AND expiry> CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 1 AND blocked = 0
               THEN 'ConcurrentTx'
        WHEN id_tag = 'B4A63CDF' AND expiry< CAST(CURRENT_TIMESTAMP AS DATE) AND In_transaction = 0 AND blocked = 0
               THEN 'Expired'
               ELSE 'Invalid'
    END 
FROM T

回复收藏 0 原文

~没有更多了~