Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: T-SQL
Expertise: Beginner
May 29, 2003

Boolean Operations Between Bit Variables in SQL

Use Bitwise Operators in T-SQL to do AND/OR/XOR (&/|/^) between two or more bit/integer variables.

You can use z = x and y in VB where x,y,z is Boolean, in T-SQL:


SET @z =
@x & @y
Or swap two Integer variables:

DECLARE @X int, @y int

SET @x = 5
SET @y = 6

SELECT @x as X, @y as Y

SET @x = @x ^ @y
SET @y = @y ^ @x
SET @x = @x ^ @y

SELECT @x as X, @y as Y
Daniel Nagdimunov
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap