SQL Server - Compare int values in a select clause

Posted by Russell on Stack Overflow See other posts from Stack Overflow or by Russell
Published on 2010-03-25T22:26:33Z Indexed on 2010/03/25 22:43 UTC
Read the original article Hit count: 296

Filed under:

This is what I thought would be a simple select clause, however the following is giving me grief! I am using SQL Server 2008.

Basically I want to compare two integer values and return the boolean result in the select clause. Here is a simple example:

DECLARE @A INT
DECLARE @B INT
SET @A = 1
SET @B = 2

SELECT @A = @B

Currently the only output is "Command(s) completed successfully." Where I reasonably believe it is assigning @A to @B.

I thought this would be simple but have not been able to achieve this.

Any help would be great! Thanks

© Stack Overflow or respective owner

Related posts about sql-server