title: What is the Max number of Columns allowed in SQL Server 2008 View?
body: <p>More of a curious question I can't seem to quickly find an definite answer to. </p>
  
  <p>In SQL Server 2008 is there a max limitation on the number of columns that are allowed in a view? From the MSDN article (below) I see that there is a limit of 4096 Columns per Select statement. Would this then be applied to a View?</p>
  
  <p>Example:</p>
  
  <pre><code>CREATE VIEW [dbo].[TestView]
  AS
  SELECT     Column1, Column2 FROM dbo.SomeTableName
  </code></pre>
  
  <p>Would I be limited to 4096 columns in this view? </p>
  
  <p><a href="http://msdn.microsoft.com/en-us/library/ms143432.aspx" rel="noreferrer">http://msdn.microsoft.com/en-us/library/ms143432.aspx</a></p>