In this post I will be showing you how to create SQL Azure Database, Tables and input data to a table.
Create SQL Azure Database
Step 1: Go to Administration page and Click create database icon.
Step 2: Input Database name, Edition and Collation. Finally click submit button
You will see the below screen after database creation.
This is the query performance screen. It contains query execution details.
Database creation is over now.
Create a Table
Step 1: Go to design page and click New Table.
Image given below is the default view of Table design. You can add or delete columns here.
Step 2: Once the table design is completed, you have to save the changes by clicking Save button in the menu. You can also give your table name in the table name text box
You can create indexes and create key relationship in this page
Input data to the table. you can also see an additional tab “Spatial Data” for geographical data.
Click Add row to enter some values for the table. This page only allow you to input non spatial column. Don’t forget to save the data. Save button is in the menu.
Update Geography column with the following queries in query execution page.
update tblFields set FieldLocation = geography::Point(29.9507768, -95.1846539, 4326) where FieldID = 1
update tblFields set FieldLocation = geography::Point(37.664654, -120.1857423, 4326) where FieldID = 2
update tblFields set FieldLocation = geography::Point(46.9102903, -103.0229563, 4326) where FieldID = 3
Now, go to Data tab and refresh the data using refresh button and then navigate to spatial data page to see the geographical data output. There are some settings available on the right hand side of this page to set up geodata visualization.