Sql server updating data in a view
The SQL Server 2012 RTM versions of the Adventure Works OLTP sample database and Adventure Works data warehouse sample database are available on Adventure Works for SQL Server 2012.SQL Server 2008R2 product code samples are available here.I have seen your previous tips (Export data from SQL Server to Excel and Different Options for Importing Data into SQL Server) related to working with Excel and SQL Server data.
We're proud to have such smart folks in our community!!
Download the Adventure Works 2008R2 family of sample databases and Adventure Works 2008R2 sample databases Note: When you click the big Download button on the SQL Server R2 sample code project page (this one), you will get the x64 installer and download the SQL Server 2008R2 samples.
SQL Azure Adventure Works community sample databases can be downloaded from here. Download the Adventure Works 2008 family of sample databases separately.
In addition, by using the commands listed above versus a two step process the overall code may be a little bit cleaner.
A second consideration with SQL Server 2005 is that the Surface Area Configuration setting must be enabled to use this code in either case.