How do I compare two columns for equality in SQL Server?

by

What’s wrong with CASE for this? In order to see the result, you’ll need at least a byte, and that’s what you get with a single character. 

CASE WHEN COLUMN1 = COLUMN2 THEN '1' ELSE '0' END AS MyDesiredResult

should work fine, and for all intents and purposes accomplishes the same thing as using a bit field.

More Related Contents:

  1. Convert text to system date format [duplicate]
  2. How to get a particular preceding value of a column in SQL [closed]
  3. SQL where clause odd behavior [closed]
  4. How do I obtain a Query Execution Plan in SQL Server?
  5. How do I escape a single quote in SQL Server?
  6. Simple way to transpose columns and rows in SQL?
  7. What is the meaning of the prefix N in T-SQL statements and when should I use it?
  8. Only inserting a row if it’s not already there
  9. Unpivot with column name
  10. Selecting data from two different servers in SQL Server
  11. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  12. Most efficient way in SQL Server to get date from date+time?
  13. Convert varchar into datetime in SQL Server
  14. Generate SQL Create Scripts for existing tables with Query
  15. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  16. How do I delete from multiple tables using INNER JOIN in SQL server
  17. SQL : BETWEEN vs =
  18. How do I perform a GROUP BY on an aliased column in SQL Server?
  19. How do I make a composite key with SQL Server Management Studio?
  20. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  21. CTE error: “Types don’t match between the anchor and the recursive part”
  22. TransactSQL to run another TransactSQL script
  23. How do I remove extended ASCII characters from a string in T-SQL?
  24. Getting Dates between a range of dates
  25. The most elegant way to generate permutations in SQL server
  26. Database Naming Conventions by Microsoft?
  27. Convert date to YYYYMM format
  28. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  29. Date serial in SQL?
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment