How to set bool value in SQL

by

Sql server does not expose a boolean data type which can be used in queries.
Instead, it has a bit data type where the possible values are 0 or 1.
So to answer your question, you should use 1 to indicate a true value, 0 to indicate a false value, or null to indicate an unknown value.

Update [mydb].[dbo].[myTable]
SET isTrue =
CASE WHEN Name="Jason" THEN 
    1
ELSE 
    0
END

More Related Contents:

  1. AFTER DELETE Trigger is not inserting multiple rows [closed]
  2. Foreign key constraint may cause cycles or multiple cascade paths?
  3. How do I perform an IF…THEN in an SQL SELECT?
  4. Inserting multiple rows in a single SQL query? [duplicate]
  5. Passing a varchar full of comma delimited values to a SQL Server IN function
  6. In SQL, how can you “group by” in ranges?
  7. How to combine date from one field with time from another field – MS SQL Server
  8. How to do a case sensitive search in WHERE clause (I’m using SQL Server)?
  9. Pivot Table and Concatenate Columns
  10. Natural join in SQL Server
  11. Pivot using SQL Server 2000
  12. Transfer data from one database to another database
  13. Sequence vs identity
  14. How to update and order by using ms sql
  15. Using Excel VBA to run SQL query
  16. The backend version is not supported to design database diagrams or tables
  17. Split string and take last element
  18. Can I set ignore_dup_key on for a primary key?
  19. How do I add a auto_increment primary key in SQL Server database?
  20. SQL Row_Number() function in Where Clause
  21. Converting Select results into Insert script – SQL Server
  22. Is it possible to execute a text file from SQL query?
  23. SELECT query with CASE condition and SUM()
  24. Select statement to return parent and infinite children
  25. How to quickly edit values in table in SQL Server Management Studio?
  26. Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
  27. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  28. Is there a quick way to check if ANY column is NULL?
  29. Ambiguous column name error
  30. SQL query for parent-child chain

Leave a Comment