Introduction

Previous Posts that you should review

bullet

Step 1
hyperlink

http://blogs.msdn.com/b/brunoterkaly/archive/2010/06/12/creating-an-on-premise-database-and-mvc-web-application-and-migrating-to-windows-azure-and-sql-azure-step-1-of-10.aspx

bullet

Step 2
hyperlink[4]

http://blogs.msdn.com/b/brunoterkaly/archive/2010/06/11/creating-an-on-premise-database-and-mvc-web-application-and-migrating-to-windows-azure-and-sql-azure.aspx

bullet

Step 3
hyperlink[6]

http://blogs.msdn.com/b/brunoterkaly/archive/2010/06/27/creating-an-on-premise-database-and-mvc-web-application-and-migrating-to-windows-azure-and-sql-azure-step-3-of-10.aspx

This Post - SQL Server Management Studio
This post will focus on using SQL Server Management Studio to display and manipulate data. Obviously, our MVC app will display the data that we manipulate from SQL Server Management Studio.
MyImage
snap0083

Start by selecting the previously inserted data from the database 

Displaying data from the stocks table
You will note that the data is exactly the same as the data we already inserted.
snap0084
 
snap0085
 
snap0086

Update the database

Issue an update statement
Notice we are changing the Description in the stocks table
snap0087
 
snap0088

Making sure the browser displays the new data

Simply hit Refresh
You should see the updated data
snap0089
 

snap0090

Next blog post

Porting our data to SQL Azure
The next post will illustrate how to migrate our data to SQL Azure, from the on-premise version of the SQL Server database.