在SQL Server 中,你可以使用带有WHERE子句的CASE WHEN表达式来根据条件进行不同的操作。以下是一个示例,展示了如何使用这种表达式: SELECT CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 -- 可以添加更多的 WHEN 子句 ELSE default_result END AS result_column FROM your_table WHERE condition;...
其实where后用也行，例句 SELECT * FROM CUSTOMERS WHERE DEPT_CODE = (CASE @ZTYPE WHEN 1 THEN @ZVALUE ELSE DEPT_CODE END)AND CITY = (CASE @ZTYPE WHEN 2 THEN @ZVALUE ELSE CITY END)...
select * from #temp A where (case when LEN(A.startMonth)=1 and A.startMonth!=0 then cast((CAST(startYear as varchar(4))+'0'+cast(A.startMonth as varchar(1))) as date) when LEN(A.startMonth)=2 then cast(CAST(startYear as varchar(4))+cast(A.startMonth as varchar(2)) as ...
select * from #temp A where (case when LEN(A.startMonth)=1 and A.startMonth!=0 then cast((CAST(startYear as varchar(4))+'0'+cast(A.startMonth as varchar(1))) as date) when LEN(A.startMonth)=2 then cast(CAST(startYear as varchar(4))+cast(A.startMonth as varchar(2)) as ...
END –Case搜索函数（WHEN 后还可以用 AND ,OR ） CASE WHEN sex = ‘1’ THEN ‘男’ WHEN sex...
1> UPDATE t_test_sub set value = 'test' WHERE case when id>10 then 1 else 0 end = 1 2> go (5 行受影响)1> SELECT * FROM t_test_sub;2> go id main_id value --- --- --- 2 12 TWOTWO 11 21 test 12 22 test 13 NULL test 14 NULL test ...
sql 中 case when 语法 2009-06-03 23:29 − sql语言中有没有类似C语言中的switch case的语句?? 没有,用case when 来代替就行了. 例如,下面的语句显... 钱途无梁 6 179720 mysql 语句case when 2010-09-21 17:08 − 表的创建 CREATE TABLE `lee` (`id` int(10) NOT NULL AUTO_INCRE...
SQL server的case when是我们经常使用的，下面小编给大家分享一下如何使用。方法/步骤 1 首先准备一个要操作的数据表，如下图所示 2 然后就可以直接case加字段，然后罗列内容了 3 另外也可以进行多条件判断，如下图所示 4 然后在实际使用中他也经常和sum函数搭配，如下图所示 5 接着最常用的就是行列转换了，如...
这样就可以了 select B.bCol_1,B.bCol_2,C.cCol_1 from TBL_B B left join TBL_C C on B.bCol_Key = C.cCol_Key where (B.bCol_Time < 'xxxx' and B.bCol_Flag<>0) or ( C.cCol_Time < 'xxxx' and B.bCol_Flag=0)...