title: SQL Server 2008 CONVERT statement in VIEW makes the data type NULL in column definition
body: <p>Here is my example view (contrived I know but shows my problem):</p>
  
  <pre><code>CREATE VIEW NullTest
  AS
  SELECT
      1 AS IntNoConvert, 
      CONVERT(BIT, 1) AS IntConvert, 
      CAST(1 AS BIT) AS IntCast
  </code></pre>
  
  <p>The final views as the data types as:</p>
  
  <pre><code>IntNoConvert (int, not null)
  IntConvert (bit, null)
  IntCast (bit null)
  </code></pre>
  
  <p>So the CONVERT and CAST make the column allow NULLs - not normally a problem in views but am I am using LinqToSql ontop of this, I need the datatypes to be NOT NULL.</p>
  
  <p>Any ideas how to make the CONVERT statement return the data as NOT NULL?</p>