请帮助语法之间的案例 [英] Please Help Case Between Syntax

问题描述

没有得到正确的输出

i想要如果孩子26然后等级3

Not getting proper Output
i want if Child 26 then level 3

declare  @level numeric(18)
declare  @Child numeric(18)=26
set @level=(  CASE 
 WHEN @Child < 5 THEN 0
 WHEN @Child  BETWEEN (0 AND 5)      THEN 1
 WHEN @Child BETWEEN (5 AND 25)  THEN 2
 WHEN @Child BETWEEN (25 AND 125)  THEN 3
 WHEN @Child  BETWEEN (125 AND 625)  THEN 4
 WHEN @Child  BETWEEN (625 AND 3125) THEN 5
 WHEN @Child  BETWEEN (3125 AND 15625) THEN 6
 WHEN @Child  BETWEEN (15625 AND 78125) THEN 7
 WHEN @Child BETWEEN (78125 AND 390625)THEN 8
 WHEN @Child  BETWEEN (390625 AND 1953125) THEN 9
 WHEN  @Child BETWEEN (1953125 AND 9765625) THEN 10
 END  )
 
 select @level
 select @Child 

推荐答案

请检查这个....

Please check this....

declare  @level numeric(18)
declare  @Child numeric(18)=26
set @level=(  
	CASE 
		 WHEN @Child < 0 THEN 0   
		 WHEN @Child  BETWEEN 0 AND 5 THEN 1
		 WHEN @Child BETWEEN 5 AND 25  THEN 2
		 WHEN @Child BETWEEN 25 AND 125  THEN 3
		 WHEN @Child  BETWEEN 125 AND 625  THEN 4
		 WHEN @Child  BETWEEN 625 AND 3125 THEN 5
		 WHEN @Child  BETWEEN 3125 AND 15625 THEN 6
		 WHEN @Child  BETWEEN 15625 AND 78125 THEN 7
		 WHEN @Child BETWEEN 78125 AND 390625THEN 8
		 WHEN @Child  BETWEEN 390625 AND 1953125 THEN 9
		 WHEN  @Child BETWEEN 1953125 AND 9765625 THEN 10
	END ) 

SELECT @level AS Level
SELECT @Child AS Child

1）你正在检查@Child< 5那么0，在第二种情况下，你正在检查@Child BETWEEN 0和5然后1，所以你的代码总是为0，如果child小于5，则不是第二种情况为1，它总是返回0为0,1,2,3 ，4,5



2）从 BETWEEN

中删除（和）广告

从你的代码我得到3当孩子26（如你所料）。刚从你的tsql查询中删除第一个breakete（）

From your code i got 3 when child 26(as you expected). Just removed first breakete() from your tsql query inside

declare  @level numeric(18)
declare  @Child numeric(18)=26
set @level=(  CASE 
 WHEN @Child < 5 THEN 0
 WHEN @Child  BETWEEN 0 AND 5      THEN 1
 WHEN @Child BETWEEN 5 AND 25  THEN 2
 WHEN @Child BETWEEN 25 AND 125  THEN 3
 WHEN @Child  BETWEEN 125 AND 625  THEN 4
 WHEN @Child  BETWEEN 625 AND 3125 THEN 5
 WHEN @Child  BETWEEN 3125 AND 15625 THEN 6
 WHEN @Child  BETWEEN 15625 AND 78125 THEN 7
 WHEN @Child BETWEEN 78125 AND 390625 THEN 8
 WHEN @Child  BETWEEN 390625 AND 1953125 THEN 9
 WHEN  @Child BETWEEN 1953125 AND 9765625 THEN 10
 END  );

select @level

s选举@Child

select @level
select @Child

这篇关于请帮助语法之间的案例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！