如果是MSSQL语句的声明 [英] If else Statement by MSSQL Statement

查看：99 发布时间：2019/6/17 11:08:23 C#

本文介绍了如果是MSSQL语句的声明的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

我该怎么写select语句包括if else condititon

我写下面的语句并给出错误，所以我应该怎么写呢

how should I write for select statement including if else condititon

I write as below statement and give error, so how should I write for that

ORDER.Order_Id as 'id',
ORDER.Released
IF(ORDER.Released = 1) PRINT 'Released'
ELSE PRINT 'Not Released'
from ORDER

谢谢，

ttds

thanks,
ttds

这应该这样做

This should do it

SELECT
    O.Order_ID AS 'id',
    O.Released,
    CASE WHEN O.Released = 1 THEN 'Released' ELSE 'Not Released' END AS ReleaseStatus
FROM Order AS O

这篇关于如果是MSSQL语句的声明的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文