<div>
<div class="content wysiwyg-content">
I have a view that I want to add a new column to and be able to enter static values for reference. Thanks for any assistance.<br />
<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2014/01_w04/829924/SQL-View-example.bmp" target="_blank" title="Example of current view to add new column (4 KB)"><img alt="Example of current view to add new column" class="file-block lazyload" style="max-width: 450px;" data-src="https://filedb.experts-exchange.com/incoming/2014/01_w04/829924/SQL-View-example.bmp" /></a>
</div>
</div>


Example of current view to add new column

SQL-View-example.bmp

I have a view that I want to add a new column to and be able to enter static values for reference. Thanks for any assistance.

 

Add a column to SQL View (sql 2008r2)

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.