How to make a view column NOT NULL

by

You can achieve what you want by re-arranging your query a bit. The trick is that the ISNULL has to be on the outside before SQL Server will understand that the resulting value can never be NULL.

SELECT ISNULL(CAST(
    CASE Status
        WHEN 3 THEN 1  
        ELSE 0  
    END AS bit), 0) AS HasStatus  
FROM dbo.Product

One reason I actually find this useful is when using an ORM and you do not want the resulting value mapped to a nullable type. It can make things easier all around if your application sees the value as never possibly being null. Then you don’t have to write code to handle null exceptions, etc.

More Related Contents:

  1. Efficiently convert rows to columns in sql server
  2. How can I get column names from a table in SQL Server?
  3. How can I select the first day of a month in SQL?
  4. Select statement to find duplicates on certain fields
  5. Using a Variable in OPENROWSET Query
  6. How to find current transaction level?
  7. Check for file exists or not in sql server?
  8. How to cast variables in T-SQL for bulk insert?
  9. How to create a PivotTable in Transact/SQL?
  10. Group DateTime into 5,15,30 and 60 minute intervals
  11. concatenate two database columns into one resultset column
  12. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  13. T-SQL and the WHERE LIKE %Parameter% clause
  14. Custom aggregate function (concat) in SQL Server
  15. Which SQL query is faster? Filter on Join criteria or Where clause?
  16. UPDATE and REPLACE part of a string
  17. Improve SQL Server query performance on large tables
  18. Average of multiple columns
  19. Show all rows that have certain columns duplicated
  20. Restrict varchar() column to specific values?
  21. How to subtract 30 days from the current date using SQL Server
  22. Count records for every month in a year
  23. How to export data from Excel spreadsheet to Sql Server 2008 table
  24. SQL Server: +(unary) operator on non-numeric Strings
  25. Use one CTE many times
  26. Bulk insert using stored procedure
  27. Connect different Windows User in SQL Server Management Studio (2005 or later)
  28. How to Select Every Row Where Column Value is NOT Distinct
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment