blocks|key|1180564|text|使用模运算符n+%25+2。如果数字是偶数，则返回0；如果数字是奇数，则返回1。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1180565|entityMap^0|6|5|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Use the modulus operator <code>n % 2</code>. It returns 0 if the number is even, and 1 if the number is odd.

blocks|key|1180693|text|还可以使用sql+server位运算符。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1180694|DECLARE+@Int+INT

SELECT+@Int+=+103

SELECT+@Int+&+1,+@Int+%25+2|code-block|syntax|javascript|1180695|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can also use sql server BIT WISE operators

<pre><code>DECLARE @Int INT

SELECT @Int = 103

SELECT @Int &amp; 1, @Int % 2
</code></pre>

blocks|key|1180804|text|我在MS+SQL+SP中使用相同的东西，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1180805|IF+@current_number+%25+2+=+0+SET+@something+=+1+|code-block|syntax|javascript|1180806|-或者--|1180807|IF+@current_number+%25+2+=+0+exec+sp_whatever|1180808|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I am using the same thing in MS SQL SP as follows:

<pre><code>IF @current_number % 2 = 0 SET @something = 1 
</code></pre>

-- or --

<pre><code>IF @current_number % 2 = 0 exec sp_whatever
</code></pre>

blocks|key|1180617|text|使用modulus+operator+(%25)。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1180618|x+%25+2|code-block|syntax|javascript|1180619|会告诉你x是偶数还是奇数。|1180620|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/aa276866(SQL.80).aspx)^0|2|K|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|C|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

Use the <a href="http://msdn.microsoft.com/en-us/library/aa276866(SQL.80).aspx" rel="nofollow noreferrer">modulus operator (%)</a>.

<pre><code>x % 2
</code></pre>

will tell you if x is even or odd.

blocks|key|1180873|text|比方说一个桌子工作台。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1180874|模式：|1180875|ID号|1180876|CITY+VARCHAR|1180877|状态VARCHAR|1180878|--+You+can+use+any+of+the+mentioned+criteria+to+fetch+the+even+ID.

--+1.+MOD()+Fucntion

select+distinct+CITY+from+STATION+as+st+where+MOD(st.id,++2)+=+0

--+2.+%25+function

select+distinct+CITY+from+STATION+as+st+where+st.id+%25+2+=+0|code-block|syntax|javascript|1180879|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|U|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|V|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Let's say for a table STATION.

Schema:

ID NUMBER

CITY VARCHAR

STATE VARCHAR

<pre class="lang-sql prettyprint-override"><code>-- You can use any of the mentioned criteria to fetch the even ID.

-- 1. MOD() Fucntion

select distinct CITY from STATION as st where MOD(st.id, 2) = 0

-- 2. % function

select distinct CITY from STATION as st where st.id % 2 = 0
</code></pre>

blocks|key|1180951|text|不适合作为一个严肃的ANSWER...BUT+IT工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1180952|请把以下内容留给那些你不喜欢的人，他们只是想要一个快速的答案，而不想理解解决方案(即想要作弊的人)。|1180953|--Enter+the+whole+integer+you+want+to+check
declare+@number+int+=+115

--The+check+is+independent+of+sign
set+@number+=+abs(@number)
declare+@OriginalNumber+int+=+@number

--Firstly,+we+need+to+peform+the+Wilhelm+Leibniz+conversion,+64+length+to+allow+for+very+big+numbers
declare+@WilhelmLeibnizConversion+varchar(64)+=+''

declare+@currentBit+int+=+power(8,exp(log(1))%2B1)

while+@currentBit+>+0
begin

++++set+@WilhelmLeibnizConversion=convert(char(1),+@number+%25+2)+%2B+@WilhelmLeibnizConversion

++++set+@number+=+convert(int,+(@number+/+2))+

++++set+@currentBit-=1

end

--Although+checking+the+1+bit+value+of+the+Wilhelm+Leibniz+conversion+is+usually+enough,+for+robust+code+you+should+also+include+the+Kimmo+Eriksson+Factors+one+and+two.
declare+@KimmoErikssonFactor1+int+=+(@OriginalNumber+%2B+1)+%25+2
declare+@KimmoErikssonFactor2+int+=+(@OriginalNumber+-+1)+&+1

--Now+check+all+3+for+100%25+confirmation+on+the+parity+of+your+original+number.
select+case+when+right(@WilhelmLeibnizConversion,1)+=+0+and+(@KimmoErikssonFactor1+%2B+@KimmoErikssonFactor2+<>+0)+then+'Even'+else+'Odd'+end|code-block|syntax|javascript|1180954|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

NOT INTENDED AS A SERIOUS ANSWER...BUT IT WORKS.

Please reserve the following for giving to people you don't like who simply want a quick answer without wanting to understand the solution (i.e people wanting to cheat).

<pre><code>--Enter the whole integer you want to check
declare @number int = 115

--The check is independent of sign
set @number = abs(@number)
declare @OriginalNumber int = @number

--Firstly, we need to peform the Wilhelm Leibniz conversion, 64 length to allow for very big numbers
declare @WilhelmLeibnizConversion varchar(64) = ''

declare @currentBit int = power(8,exp(log(1))+1)

while @currentBit &gt; 0
begin

 set @WilhelmLeibnizConversion=convert(char(1), @number % 2) + @WilhelmLeibnizConversion

 set @number = convert(int, (@number / 2)) 

 set @currentBit-=1

end

--Although checking the 1 bit value of the Wilhelm Leibniz conversion is usually enough, for robust code you should also include the Kimmo Eriksson Factors one and two.
declare @KimmoErikssonFactor1 int = (@OriginalNumber + 1) % 2
declare @KimmoErikssonFactor2 int = (@OriginalNumber - 1) &amp; 1

--Now check all 3 for 100% confirmation on the parity of your original number.
select case when right(@WilhelmLeibnizConversion,1) = 0 and (@KimmoErikssonFactor1 + @KimmoErikssonFactor2 &lt;&gt; 0) then 'Even' else 'Odd' end
</code></pre>

blocks|key|1180756|text|您可以检查数字的十六进制值的1位。如果该位为on，则它是奇数。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1180757|DECLARE+@Int+INT

SELECT+CASE+WHEN+@Int&0x0001<>0+THEN+'ODD'+ELSE+'EVEN'+END|code-block|syntax|javascript|1180758|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You could check the 1-bit of the hex value of the number. If that bit is on, then it is odd.

<pre><code>DECLARE @Int INT

SELECT CASE WHEN @Int&amp;0x0001&lt;&gt;0 THEN 'ODD' ELSE 'EVEN' END
</code></pre>

blocks|key|1396426|text|%25运算符检索模数，因此检查除以2的模数可以知道它是奇数还是偶数。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1396427|DECLARE+@i+int+=1;
while+@i+<=+20
begin+
++++if+@i+%25+2+=+0
++++PRINT+@i
++++IF+@i+=+10+PRINT+'halfway+there!';
++++set+@i+=+@i%2B1;
end|code-block|syntax|javascript|1396428|entityMap^0|0|1|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

The <code>%</code> operator retrieves the modulus, so checking the modulus of a division by 2 you can know if it is odd or even.
<pre><code>DECLARE @i int =1;
while @i &lt;= 20
begin 
 if @i % 2 = 0
 PRINT @i
 IF @i = 10 PRINT 'halfway there!';
 set @i = @i+1;
end
</code></pre>

blocks|key|1396245|text|USE+AdventureWorks;
GO

SELECT+BusinessEntityID,
++++CASE+BusinessEntityID+%25+2
++++WHEN+0+THEN+'Even'+ELSE+'Odd'+END+AS+"Status"
FROM+HumanResources.Employee;
GO|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1396246|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>USE AdventureWorks;
GO

SELECT BusinessEntityID,
 CASE BusinessEntityID % 2
 WHEN 0 THEN 'Even' ELSE 'Odd' END AS "Status"
FROM HumanResources.Employee;
GO
</code></pre>

Bit rusty on the old sql.

Can you help?

Given a number eg 1 or 2 or 4 I need to determine if it's even or odd number and do some calculation 
depending if even or odd .

How do you detect that in sql (sql server 2000)
thanks a lot

How Can I determine is digit Even number?

在旧的sql上有点生疏。你能帮上忙吗？给定一个数字，例如1、2或4，我需要确定它是偶数还是奇数，并根据偶数或奇数进行一些计算。如何在sql (sql server 2000)中检测到这一点?谢谢！

问如何判断数字是否为偶数？
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何判断数字是否为偶数？EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何判断数字是否为偶数？
EN